Troubleshooting.

Troubleshooting Microsoft SQL Server 2008.

Cannot Launch Activity Monitor for a SQL SQL Server 2000 Instance
The new Activity Monitor does not support SQL Server 2000.

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.

Restart Computer Failed
Trying to install SQL Server 2008 Developer edition setup fails at the Setup Support Rules page on the Rule "Restart Computer".

The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
Error received when you try to store dates earlier than year 1753 on datetime fields.
 

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 access the specified path or file on the server.
Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists.

 

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.

KB955706 failed to install
We received the following error installing SP3 on a SQL Server 2005 Developer Edition: "A recently applied update, KB955706, failed to install".

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

Login Failed for User Error 18452
Windows cannot query for the list of Group Policy objects. The kerberos subsystem encountered a PAC verification failure. The Security System could not establish a secured connection with the server. The kerberos client received a KRB_AP_ERR_MODIFIED error from the server.

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>

Property IsLocked is not available for login
This property may not exist for this object, or may not be retrievable due to insufficient access rights.

 

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>].

Successful Installation SP3 not Applied on Server
After a successful installation of SQL Server 2005 Sp3 the instance is still at SP2.

The Operating System Returned Error 21
The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 0x00000000056000 in file 'XXXX'.

 

The SQLBrowser service was unable to establish Analysis Services discovery

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

The Transaction Manager is not available
Hotfix.log: MSP Error 29549 Failed to install and configure assemblies. Error: -2146233087. Error message: Unknown error 0x80131501. Error description: The Transaction Manager is not available. (Exception from HRESULT: 0x8004D01B)

 

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'.

Failed to Create Configuration Database
SharePoint Products Configuration Wizard. Configuration Failed. Failed to create the configuration database. An exception of type System.IO.FileNotFoundException was thrown.

 

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.

Starting Up Database
Examining the SQL Server error log of a Microsoft SQL Server 2005 Express Instance, we found the following record repeated many times:  Starting up database 'DatabaseName'.

The Media Family on Device is Incorrectly Formed
The media family on device 'Backupfile.bak' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)
 

Troubleshooting Microsoft SQL Server 2000.

Backup Log is terminating abnormally.
'LogicalBackupDevice_Voice' failed, status = 112. See the SQL Server error log for more details. [SQLSTATE 42000] (Error 3202) BACKUP LOG is terminating abnormally.

Buffer Cache Hit Ratio Very Low.
Low readings for the buffer cache hit ratio.

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).

Huge SQLAGENT.OUT log file.
The error log file for the SQL server Agent service is taking a huge amount of disk space.

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

Invalid Input Trace File.
Microsoft.SqlServer.BestPracticesAnalyzer.UpgradeAdvisor
Invalid input trace file or the version of the trace file filename.trc is not supported.

 

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.

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.

Cannot Open User Default Database.
Workflow Subscriber Configuration Utility
Cannot open user default database. Login failed. Login failed for user 'laserfiche'.

Create Database Permission Denied.
Error has occurred while configuring Laserfiche Workflow 8.

Database <databasename> exists but it is unaccessible.
HP Data Protector is trying to backup databases that are "offline".

Error has occurred while opening database 'DBName'.
Check if the database exists on the server. See Data Protector debug.log and SQL Server error log for details.

 

Error Installing SCOM 2007 Database.
Setup cannot locate the SC database. Setup could not locate the SC database on the specified server. Invalid Microsoft Operations Manager Database Version

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.'

Error Registering Laserfiche Repository.
Laserfiche Repository Wizard. Could not connect to SQL Server to verify that the database exists. Do you want to continue?

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

INSERT failed because the following SET options have incorrect settings.
This error message appeared on the screen while configuring ePolicy Orchestrator 4.0.

Invalid Operations Manager Database Version.
Setup found that the Microsoft Operations Manager database version on the specified database server is not the same as the current product version.

jTDS Exception Connection Refused.
java.sql.SQLException: Network error IOException: Connection refused: connect at net.sourceforge.jtds.jdbc.ConnectionJDBC2

 

jTDS Exception - Connection Timed Out.
SQLException while getting database connection. Check if database daemon is running java.sql.SQLException: Network error IOException: Connection timed out: connect at net.sourceforge.jtds.jdbc.ConnectionJDBC2.

ODBC Error Installing VMware vSphere.
VMware vCenter Server. The DSN, 'vcenter' does not exist or is not a 32 bit system DSN. vCenter Server requires a 32 bit system DSN.

ORA-00904 Invalid Identifier.
OLE DB provider "MSDAORA" for linked server "ODBCDataSource" returned message "ORA-00904: : invalid identifier".

ORA-12704 character set mismatch.
Error creating a report in Business Objects that was using a query, joining tables from an Oracle server and a SQL Server 2005 instance.

This Recordset Is Not Updatable.
When you try to update, delete or insert a record on a table in an Access Project, Microsoft Access beeps, and you receive an error in the status bar.
 

Troubleshooting SQL Azure.

Cannot Connect to SQL Azure.
Connect to Server. Cannot connect to hhkxxxxxxx.database.windows.net. An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo). Invalid object name ‘sys.configurations’. (Microsoft SQL Server, Error: 208).
 

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