[Company Logo Image] 

Home Contents Coffee Break Credits Glossary Links Search

 Troubleshooting
 

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
SQL Server 2008
SQL Server 2012
SQL Server 2014
Tips
Troubleshooting
Tuning

Troubleshooting.

 

Troubleshooting Microsoft SQL Server 2014 (Hekaton).


Error Applying the Filestream Settings.
There was an unknown error applying the filestream settings. Check the parameters are valid. (0x80041001).

Long Path Names to Files on SQL Server Media.
Global Rules. Long path names to files on SQL Server installation media (failed).

Rule Same Architecture Installation failed.
Rule failed trying to install SQL Server Data Tools Business Intelligence for Visual Studio 2013 (SSDT-BI).

 

Troubleshooting Microsoft SQL Server 2012 (Denali).


Computer does not meet the minimum requirements.
The operating system on this computer does not meet the minimum requirements for SQL Server "Denali".

Database mssqlsystemresource is being recovered.
Error: Command execution failed: Failed to retrieve data for this request. Error: Database 'mssqlsystemresource' is being recovered. Waiting until recovery is finished.

Error SQL72014.
Error: SQL72014: .NET SqlClient Data Provider: Msg 9982, level 16, State 100, Line 1 Cannot use full-text search in user instance.

Error while enabling Windows feature NetFx3.
Error while enabling Windows feature: NetFx3, Error Code: -2146498298, Please try enabling
Windows feature: NetFx3 from Windows management tools and then run setup again.

LocalDB not supported on this OS.
Installation of this product failed because it is not supported on this operating system.

Microsoft SQL Server Error 950.
Database 'Northwind' cannot be upgraded because its non-release version (539) is not supported by this version of SQL Server. You cannot open a database that is incompatible with this version of sqlservr.exe.
 
Msg 7399 Msg 7303 OPENROWSET.
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".

SQL Server Setup Rules Failed.
RULE: There is an internet connection to Microsoft .NET Framework 4.0 download center (failed). RULE: Microsoft .NET Framework 3.5 Service Pack 1 is required (failed).

The Project Cannot Be Debugged.
Microsoft SQL Server Report Designer. The project cannot be debugged because no starting report is specified.

Try_convert is not a recognized function.
Msg 195, Level 15, State 10, Line 1. 'TRY_CONVERT' is not a recognized built-in function name.

 

Troubleshooting Microsoft SQL Server 2008 R2 (Kilimanjaro).


Cannot create a linked server to Oracle
Cannot create an instance of OLE DB Provider "OraOLEDB.Oracle" for linked server "RH6I".
(Microsoft SQL Server, Error: 7302).

Change Pending State
Exit code (Decimal): -2068709375. Exit facility code: 1202. Exit error code: 1. The NT service 'SQLSERVERAGENT' could not be started.

Service Broker Error 28054
Error: 28054, Severity: 11, State: 1. Service Broker needs to access the master key in the database 'XXXX'.
 
Exit Message InstanceDir
SQL Server installation failed. Exit code (Decimal): -2068578304. Exit facility code: 1204. Exit error code: 0.

Msg 7411 Linked Server
Error trying to use EXEC() AT to run a pass-through query on a linked server. Msg 7411, Level 16, State 1, Line 1. Server 'servername' is not configured for RPC.
 
No Features Selected for Upgrade
There are no features selected for upgrade. Exit facility code: 1207. Exit error code: 1602. Exit message: User has cancelled.

Rule Windows PowerShell Failed
Error received while installing Microsoft SQL Server 2008 R2 with Advanced Services in the "Setup Support Rules" page.

Subscriber does not satisfy version compatibility
The selected Subscriber does not satisfy the minimum version compatibility level of the selected publication.

The resource governor is not available
Alter failed for ResourceGovernor 'Microsoft.SqlServer.Management.Smo.ObjectKeyBase'. (Microsoft.SqlServer.Smo). 'ALTER RESOURCE GOVERNOR RECONFIGURE' failed.

The server version is not supported
JDBC connection error while trying to connect to a SQL Server 2008 R2 instance  from a Oracle server.

Unable to modify table
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Change of safety level not allowed
Msg 1473, Level 16, State 6, Line 1. This SQL Server edition does not allow changing the safety level. ALTER DATABASE command failed.

 

Troubleshooting Microsoft SQL Server 2008 (Katmai).


Cannot connect to WMI provider 0x8004100.
You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager. Invalid class [0x8004100]

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

Cannot Resolve the Collation Conflict.
(Microsoft.SqlServer.ConnectionInfo) Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the UNION operation. (Microsoft SQL Server, Error:468)

Could not connect to the report server.
Could not connect to the report server http://computername:8080/ReportServer. Verify that the TargetServerURL is valid and that you have the correct permissions to connect to the report server.

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 Code is 2337.
The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2337.

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.

Evaluation Period Has Expired.
Learn how to upgrade an instance of SQL Server 2008 R2 Evaluation Edition (that has expired) to a licensed edition without losing any data or any configuration.
 
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".

Saving Changes Is Not Permitted
Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created.

SQL Server 2008 setup requires .NET Framework
SQL Server 2008 setup requires Microsoft .NET Framework and an updated Windows Installer to be installed.

SQL Server encountered error 0x80070218
Msg 30046, Level 16, State 1, Line 1. SQL Server encountered error 0x80070218 while communicating with full-text filter daemon host (FDHost) process.

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.

There are validation  errors on this page
Click OK to close this dialog box. Review errors at the bottom Setup page, then provide valid parameters or click Help for more information.
 

Troubleshooting Microsoft SQL Server 2005 (Yukon).

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 Kill Process with Status Suspended.
Killed process was present on the Activity Monitor with status “Suspended” and command “KILLED/ROLLBACK”.
 
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 29503 Installing SQL Server 2005.
The SQL Server service failed to start. The error is (1053) The service did not respond to the start or control request in a timely fashion. Error Number : 29503.
 
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.

Invalid attempt to GetBytes on column.
Error message is: Invalid attempt to GetBytes on column 'FECHA_GENERACION'. The GetBytes function can only be used on columns of type Text, NText, or Image.

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.

Maintenance Plan Job Failed
The job failed. The Job was invoked by User Domain\user. The last step to run was step 1 (Monday).

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>

ORA-12545 Connection failed because target host or object does not exist.
Error received while using SQL Server Migration Assistant (SSMA) 2005 for Oracle.

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

Unspecified Error
Microsoft SQL Server Management Studio. Unspecified error (MS Visual Database Tools).
 
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 (Shiloh / Liberty).


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.

Backups with EMC Networker Finish with Error 3041.
Error: 3041, Severity: 16, State: 1. BACKUP failed to complete the command BACKUP LOG SharePoint_Config.

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 Connect to Database Master.
Error received from SharePoint Products Configuration Wizard while installing SharePoint 2010.

Cannot insert the value NULL into column.
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert the value NULL into column 'CustomerId', table 'XXXXX.XX.Customer'; column does not allow null.

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 connecting to VMware vCenter Update Manager.
vSphere Client. There was an error connecting to VMware vCenter Update Manager - [computername:443]. Database temporarily unavailable or has network problems.

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.
 
Error Upgrading to VMM 2012 R2.
Setup cannot be completed. VMM management server. Virtual Machine Manager Setup cannot create a backup of the existing database. Verify that you have the necessary rights to backup the Virtual Machine Manager database, and then restart Setup.

Exception thrown while executing SQL script.
Error received while upgrading vCenter Server 4.0 to version 4.1

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.

Permissions needed to create new DB account.
The user "solarwind" does not have permission to create a new database account. You must select an existing SQL account.
 
Record Retrieval Error ConnectionRead.
Record Retrieval Error. Error: (Connection Read(recv()).(01000)) attempting to access a record from the MERCAN file. Returning to previous window.

Replica is inconsistent.
Error found on DPM 2010 Administrator Console saying “Replica is inconsistent”.

Required permissions needed to install vCenter Server.
VMware vCenter Server. The DB user entered does not have the required permissions needed to install and configure vCenter Server with the selected DB.

RollbackSnapshotTempDB.
Msg 823, Level 24, State 2, Procedure objects$, Line 2. The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 0x000000000ee000 in file '\\?\GLOBALROOT\Device\HarddiskVolumeShadowCopy452\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\WSS_Content_XXXXXXX.mdf'.


SQL Common Language Runtime is not enabled on the server.
The current user does not have privileges to enable CLR (needs to be a member of 'SysAdmin' role).

SQL Server security mode.
We received the following warning from System Center Configuration Manager setup: SQL Server security mode.

SQL Server version is not supported by SCOM 2012.
The installed version of SQL Server is not supported. Verify that the computer and installed version of SQL Server meet the minimum requirements for installation.

TF254027: You must correct all errors.
Configuring TFS 2010 using standard configuration we received the following errors: TF254027, Error [ Reporting ] TF255344, Error [ Reporting ] TF255274, Error [Reporting ] TF255151 and Warning [Project Collection] TF255331.

The system cannot find the file specified.
EMC (Legato) Networker. The system cannot find the file specified. Cannot run nsrsqlsv: The system cannot find the file specified. InstanceName1:MSSQL:database1: retried 1 times.

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.

Unable to connect to the VMM database.
Error (2605). Unable to connect to the VMM database because of a general database failure. SQL error code: 547.

VMM 2012 SP1 Setup Wizard closes unexpectedly.
Setup Wizard closes unexpectedly when we click the "Next" button on the Library Configuration page.

w3wp.exe (0x1B08).
w3wp.exe (0x1B08) 0x1AC8 SQL Server Reporting Services SOAP Client Proxy 0000 High Exception encountered for SOAP method GetSystemProperties: System.Net.WebException: Unable to connect to the remote server.
 
 

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).
 
Login Failed Windows Azure SQL Database.
Cannot connect to xxxxxx.database.windows.net. Login failed for user 'morillo'. (Microsoft SQL Server, Error: 18456).
 

 

 

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