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 memory management
Windows Internal Database
Browse by Tags
Tagged Content List
When using SSL, SQL Failover Cluster Instance fails to start with error 17182
I recently worked on an interesting issue with a SQL Server Failover Cluster Instance (FCI). We were trying to use an SSL certificate on the instance, and we followed these steps: Made sure the certificate was requested according to the requirements defined here . Loaded the certificate into the Personal...
22 Jul 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 : SQL 2012 Filetable Setup and Usage
One of the cool things about my job is that I get to work on the latest technologies earlier than most people. I recently stumbled upon an issue related to Filetables, a new feature in SQL Server 2012. To start with, a Filetable brings you the ability to view files and documents in SQL Server, and allows...
10 Nov 2012
SQL 2008/2008 R2/2012 setup disappears/fails when installing Setup Support files
I’m sure many of you would have seen this issue when running SQL 2008/2008 R2/2012 setup on a new server. The setup will proceed to install Setup support files, the window will disappear but, strangely enough, the next window never shows up. Here’s what you need to do: Click on start...
7 May 2012
Windows Server 2003 - KB 2463332 for Windows Internal Database fails to install
This is an interesting issue that I ran into, and took some time to find out the steps for resolution. What was happening was the customer was receiving repeated prompts for installing KB 2463332 for Windows Internal Database. It could, of course, have been any other update for the windows internal DB...
19 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 (6 items)
© 2014 Microsoft Corporation.
Privacy & Cookies