A blog about real-life SQL Server Troubleshooting, providing solutions that actually work. By a SQL Server Enthusiast.
A severe error occurred on the current command
all the satellite assemblies required are loadable and fully signed
An error occurred while dropping availability group
An error occurred while obtaining or using the certificate for SSL
and it is not possible to create a self-signed certificate
Availability Group does not come up
Availability Group does not come up on one instance
Availability Group does not failover
Availability Group Not Synchronizing\Recovery Pending
awe in sql
because of error 9002
Caching in SQL
cannot be started because some of the database functionality is not available in the current edition of SQL Server
Cannot insert the value NULL into column 'servername'
Case sensitive collation
Check for previous errors
Error code 1642
Exit Code Returned: 11009
Failed mirror comes online after restart
failed to find installation media path due to datastore exception in FindSetupFolder()
Failed to launch local setup100.exe: 0x80070003
Failed to obtain the Windows Server Failover Clustering (WSFC) node handle (Error code 5042)
failed to run patch request for instance
how it works
SQL Server 2008 R2
SQL 2008 R2
SQL Server 2005
SQL Server 2008
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014
SQL server memory management
Windows Internal Database
Browse by Tags
Tagged Content List
An interesting issue with Peer to Peer Replication
I recently ran into an interesting issue when setting up Peer 2 Peer Replication across 3 instances. The primary instance was SM-UTSQL, where we configured a Peer-to-Peer publication named "PUBLISH1" on the database "DDS-TRANS". Next, we proceeded to configure Peer-to-Peer topology...
1 Oct 2013
Something to watch out for when using IS_MEMBER() in TSQL
I recently worked on an interesting issue with my good friend Igor (@sqlsantos), where we were facing performance issues with a piece of code that used the IS_MEMBER () function. Basically, the IS_MEMBER function is used to find out whether the current user (windows/sql login used for the current session...
5 Aug 2013
SQL Server patch fails with "Could not find any resources appropriate for the specified culture or the neutral culture"
I recently worked on a number of issues where SQL Server Service Pack/patch installation would fail, and we would see this error in the relevant Detail.txt (located in C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\<Date time of the installation attempt> for SQL 2008/2008 R2): ...
12 Jun 2013
How To: Troubleshooting SQL Server I/O bottlenecks
One of the most common reason for server performance issues with respect to SQL Server is the presence of an I/O bottleneck on the system. When I say I/O bottleneck, it can mean issues like slow disks, other processes hogging I/O, out-dated drivers, etc. In this blog, I will seek to outline the approach...
3 Jun 2013
An interesting issue with SQL Server Script upgrade mode
Here's another common issue that I've seen quite a few people run into of late. When you run a patch against SQL Server, the patch installs successfully, but on restart, SQL goes into "script upgrade mode" and you're unable to connect to it. Upon looking at the errorlog, you see something like...
15 Apr 2013
Why the service account format matters for upgrades
I've seen this issue a few times in the past few months, so decided to blog about this. When upgrading from SQL 2005 to SQL 2008/SQL 2008 R2 (or even from SQL 2008 to SQL 2008 R2), you might face an error with the in-place upgrade. Open the setup logs folder (located in C:\Program files\Microsoft...
1 Apr 2013
SQL 2008–Service fails to come online with “a valid certificate could not be found, and it is not possible to create a self-signed certificate”
You might run into this situation where SQL Server fails to come online (either with a new install or an existing one). Looking at the application event logs, you see these messages: Event Type: Error Event Source: MSSQLSERVER Event Category: Server Event ID: 17182 Date: 05/08/2012 ...
9 Oct 2012
An interesting “Issue” with adding Windows Logins in SQL Server
Now here’s one that had me stumped for quite some time. A brief description of the issue:- 1. I have 2 instances of SQL Server set up on different servers, both with a Case sensitive collation 2. At least one of the instances is installed on a cluster. 3. The Windows version for all...
20 Mar 2012
SQL 2008/R2 setup fails with "Wait on the database engine recovery handle failed"
When installing SQL Server 2008/2008 R2, you might come across a situation where the setup fails towards the end, when trying to start the SQL Server services. You find this message in the summary.txt:- Configuration error code: 0x4BDAF9BA@1306@24 Configuration error description: Wait on the Database...
15 Mar 2012
Page 1 of 1 (9 items)
© 2015 Microsoft Corporation.
Privacy & Cookies