Browse by Tags

• access
• analysis
• assertion
• Backup
• copy
• cube
• dashboard
• database
• destination
• developer
• device
• dtaengine
• error log
• exception
• execute
• file
• high availability
• images
• Integration
• jobs
• kba
• log shipping
• login
• management
• named pipes
• not found
• operation failed
• performance
• procedure
• property
• remote
• repoting services
• scheduled
• security
• service pack
• source
• sql express
• SQL Server
• ssis
• ssma
• SSMS
• surface
• tape
• tcp
• transaction
• truncated
• unhandled
• wizard
• x64

• FIX: Error message when you use Database Engine Tuning Advisor to tune a database in SQL Server 2005 Service Pack 2: "An unhandled win32 exception occurred in dtaengine90.exe [4308]"

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX: Read More... Posted Thursday, August 30, 2007 5:38 AM from SSQA.net | (Comments Off) Filed under: SQL Server, error, service pack, kba, exception, unhandled, dtaengine

• SSIS Error: Text was truncated or one or more characters had no match in the target code page

  This error started generating since last 2 days on a scheduled job that uses SSIS to import content from a flat file. Eventually we found that a derived column within the table and the flat file flow where dates in YYYYMMDD are changed to MM/DD/YYYY format. Read More... Posted Wednesday, August 29, 2007 5:54 PM from SSQA.net | (Comments Off) Filed under: SQL Server, error, error log, jobs, ssis, truncated, destination, source, file, scheduled

• The operation has been cancelled. at Microsoft.AnalysisServices.Xmla.XmlaClient.CheckForSoapFault(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError)

  Full error text of above message while performing the backup of a Cube: The operation has been cancelled. at Microsoft.AnalysisServices.Xmla.XmlaClient.CheckForSoapFault(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError) at Microsoft.AnalysisServices.Xmla.XmlaClient.CheckForError(XmlReader Read More... Posted Tuesday, August 28, 2007 7:08 PM from SSQA.net | (Comments Off) Filed under: SQL Server, Backup, error, analysis, cube, operation failed, execute

• Property IsLocked is not available for Login '[x]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)

  One of my colleague has been getting following error when trying to open few logins properties to change their default databases using SSMS. TITLE: Microsoft SQL Server Management Studio ------------------------------ Cannot show requested dialog. ------------------------------ Read More... Posted Wednesday, August 22, 2007 11:56 PM from SSQA.net | (Comments Off) Filed under: security, SQL Server, SSMS, error, login, property, ssma

• FIX: Error 9003 is logged in the SQL Server error log file when you use log shipping in SQL Server 2005

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications Read More... Posted Wednesday, August 22, 2007 7:05 PM from SSQA.net | (Comments Off) Filed under: SQL Server, error, transaction, kba, log shipping

• [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). [ODBC SQL Server Driver][DBNETLIB]Specified SQL server not found

  --------------------------- Microsoft SQL Server Login --------------------------- Connection failed: SQLState: '01000' SQL Server Error: 11004 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). Connection failed: SQLState: '08001' Read More... Posted Wednesday, August 22, 2007 12:06 AM from SSQA.net | (Comments Off) Filed under: security, SQL Server, Integration, SSMS, error, high availability, surface, not found

• FIX: Error message when you use the UNLOAD and REWIND options to back up a database to a tape device in SQL Server 2005: "Operation on device '<TapeDevice>' exceeded retry count"

  Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications FIX: Error message when you use the UNLOAD and Read More... Posted Tuesday, August 21, 2007 8:16 AM from SSQA.net | (Comments Off) Filed under: SQL Server, Backup, error, kba, device, tape

• FIX: Error message when you use the Copy Database Wizard to move a database from SQL Server 2000 to SQL Server 2005

  Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification , Contents: New and Major Modifications FIX: Error message when you use the Copy Database Read More... Posted Tuesday, August 21, 2007 6:33 AM from SSQA.net | (Comments Off) Filed under: SQL Server, error, database, kba, copy, wizard

• FIX: Error message when you run a query that is associated with a parallel execution plan in SQL Server 2005: "SQL Server Assertion: File: <lckmgr.cpp>, line=10850 Failed Assertion = 'GetLocalLockPartition () == xactLockInfo->GetLocalLockPart

  Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX: Error message when you run a query that is Read More... Posted Monday, August 20, 2007 7:37 AM from SSQA.net | (Comments Off) Filed under: SQL Server, x64, error, error log, kba, assertion

• Reporting Services: Images are not showing properly when deployed on the live server?

  Normally I wouldn't do much development using Reporting Services, but lately I was trying to play with it to get a flashy type of report for a monitoring information on set of SQL Servers we manage. In this scenario I have developed a report that works Read More... Posted Monday, July 30, 2007 9:10 PM from SSQA.net | (Comments Off) Filed under: SQL Server, error, dashboard, images, procedure, developer, repoting services

• An error has occured while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider:Named Pipes ....)

  Error: An error has occured while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider:Named Pipes Provider,error:40-Could Read More... Posted Thursday, July 26, 2007 10:49 PM from SSQA.net | (Comments Off) Filed under: security, SQL Server, performance, SSMS, tcp, sql express, error, access, named pipes, remote, management