Troubleshooting.

Troubleshooting Microsoft SQL Server 2008.

Detach Database Failed for Server. (Microsoft.SqlServer.Smo)
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo). Cannot execute 'sp_updatestats' because the database is in read-only access mode. Cannot DETACH a database snapshot. (Microsoft SQL Server, Error: 15635)

Error Reverting a Database to a DB Snapshot.
Msg 5070, Level 16, State 2, Line 4. Database state cannot be changed while other users are using the database. Msg 3013, Level 16, State 1, Line 4. RESTORE DATABASE is terminating abnormally
 

Msg 6522, Level 16, State 1, Line 3  ... Aggregate 'geometry'

Msg 6522, Level 16, State 1, Line 3. A .NET Framework error occurred during execution of user defined routine or aggregate 'geometry': System.FormatException: 24141.

Msg 6522, Level 16, State 1, Line 3  ... Aggregate 'geometry' (2)

Msg 6522, Level 16, State 1, Line 3. A .NET Framework error occurred during execution of user defined routine or aggregate 'geometry': System.FormatException: 24119.

Reporting Services Catalog Error
Rules "Reporting Services Catalog Database File Existence" and "Reporting Services Catalog Temporary Database File Existence" failed after SQL Server 2008 ran a set of installation rules.
 

Troubleshooting Microsoft SQL Server 2005.

A fatal error occurred while reading the input stream from the network. The session will be terminated

Event Type: Error. Event Source: MSSQLSERVER. Event Category: (2). Event ID: 4014.

 

Cannot create new connection because in manual or distributed transaction mode.

Event Type: Error.  Event ID 3501.  Event Source:  MMArrayManager.

 

Cannot show requested dialog (SqlMgmt)

An exception occurred while executing a Transact-SQL statement or batch.(Microsoft.SqlServer.ConnectionInfo). Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222).

Cannot Start SQL Server Agent Service
[298] SQLServer Error: 22022, CryptUnprotectData() returned error -2146892987, 'The requested operation cannot be completed. The computer must be trusted for delegation and the current user account must be configured to allow delegation.' [SQLSTATE 42000]. [442] ConnConnectAndSetCryptoForXpstar failed (0).
 

Class Not Registered (Microsoft.SqlServer.SqlTools.VSIntegration).

Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG))
(Microsoft.SqlServer.SqlTools.VSIntegration).

 

Could not connect because the Maximun Number of 1 DAC Already Exists

Could not connect because the maximum number of '1' dedicated administrator connections already exists.

 

Error Creating a New Job

Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey'

to type 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'.  (Microsoft.SqlServer.Smo)

 

How to rebuild system databases in SQL Server 2005

How to rebuild the master database for a corrupted installation of SQL Server.

Login Failed for User
Source Logon. Login failed for user 'DOMAIN\user account'. [CLIENT: 192.1681.1]

MS DTC was unable to start
MS DTC was unable to start because the installation was not configured to run on a cluster.

 

MSSQLServerADHelper Event Id 100

Event Type: Error. Event Source: MSSQLServerADHelper. Event ID: 100.

MSSQLSERVER Event ID 3041

Event Type: Error. Event Source: MSSQLServer. Event ID: 3041. BACKUP failed to complete the command BACKUP DATABASE <DB Name>

 

Restore failed for Server

Restore failed for Server <Instance Name>. (Microsoft.SqlServer.Smo). Additional information: System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing <Database Name>. (Microsoft.SqlServer.Smo)

SQL Server Resource Group Failed
Event Type: Error. Event Source: MSSQLSERVER. Event ID: 17187.  SQL Server is not ready to accept new client connections. Wait a few minutes before trying again. Event Type: Error. Event Source: ClusSvc. Event ID: 1069. Cluster resource 'SQL Server' in Resource Group 'Resource_group_name' failed.

SQL Server Setup cannot install files
Event Type: Error. Event Source: MsiInstaller. Event ID: 10005. Product: Microsoft SQL Server 2005 -- Error 28062. SQL Server Setup cannot install files to the compressed or encrypted folder

 

SSPI handshake failed

SSPI handshake failed with error code 0x80090304 while establishing a connection

with integrated security; the connection has been closed. [CLIENT: <ip address>].

 

The SQLBrowser service was unable to establish Analysis Services discovery

Event Type: Warning. Event Source: SQLBrowser. Event Category: None. Event ID: 9.

 

Warning SQLSERVERAGENT Event ID 208

SQL Server Scheduled Job <job name> - Status: Failed. Message: The job failed. Unable to determine if the owner <user name> of job <job name> has server access.
 

Warning SysmonLog Event ID 2059.

Invalid user name or password for the <Instance Name> log session. This session will not be started.

 

Troubleshooting Microsoft SQL Server 2005 Express Edition.

Attach Database Failed

Attach database failed for Server 'SERVERNAME\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo). Unable to open the physical file "filename.mdf". Operating system error 5: "5(error not found)".(Microsoft SQL Server, Error: 5120)

Backup failed for Server
Backup failed for Server 'servername'. (Microsoft.SqlServer.Smo). System.Data.SqlClient.SqlError:  Cannot open backup device.   Operating system error 5(Access is denied.). (Microsoft.SqlServer.Smo)

Error MsInstaller EventId 11706

An installation package for the product Microsoft SQL Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'.

 

SQLBrowser Event Id 3

The configuration of the AdminConnection\TCP protocol in the SQL instance SQLEXPRESS is not valid. Event Type: Warning. Event Source: SQLBrowser. Event Category: None. Event ID: 3.

 

SQL Server Express 4 GB Limit

Restore failed for Server <Instance Name>. (Microsoft.SqlServer.Smo)
Additional information: System.Data.SqlClient.SqlError: CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 per database.
 

Troubleshooting Microsoft SQL Server 2000.

Error 15457 Severity 0 State 1.
Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

Error 3205 Too Many Backup Devices Specified.

Too many backup devices specified for backup or restore; only 64 are allowed.  RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3205)

Index Corruption.
Could not find the index entry for RID '160314a879010000' in index page (1:428288), index ID 3, database 'DATABASENAME'..

 

Perflib Event Id 1023.

Event Type Error. Event Id 1023. Source Perflib.

 

Property Owner is not available for Database.

Cannot show requested dialog. (SqlMgmt). Property Owner is not available for Database ’[     ]’.  This property may not exist for this object, or may not be retrievable due to insufficient access rights.
(Microsoft.SqlServer.Smo)

Purge job history failed for JobServer
Purge job history failed for JobServer 'SERVERNAME'.(Microsoft.SqlServer.Smo).  An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo). @oldest_date is not a parameter for procedure sp_purge_jobhistory. (Microsoft SQL Server, Error: 8145)

Warning Server Agents Event Id 1123.
System Information Agent: Health: Post Errors were detected. One or more Power-On-Self-Test errors were detected during server startup. [SNMP TRAP: 6027 in CPQHLTH.MIB]

Troubleshooting Applications That Use Microsoft SQL Server.

Error on Data Protector Manager.

Error has occurred while executing a SQL statement. Error message: '<Microsoft SQL-DMO (ODBC SQLState: 42000):bc5>. [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.'

BusinessObjects: Connection or SQL sentence error: (DA0005)
Exception: DBD, [Microsoft OLE DB Provider for SQL Server]: [DBNETLIB] [ConnectionOpen (PreLoginHandshake()).] General network error. Check your network documentation. State: 08001.

Error 51005: The row was not inserted in the alarm_history table.
Error: 51005, Severity: 10, State: 1. etalk Qfiniti 3.5.

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.