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 store of the computer account across…

8

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 FilesMicrosoft SQL Server100Setup BootstrapLog<Date time of the installation attempt> for SQL 2008/2008 R2):   2013-04-07 20:14:07 Slp: Package sql_bids_Cpu64: – The path of cached MSI package…

0

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,…

19

SQL 2008/2008 R2/2012/2014 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/2014 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->run and type %temp% and…

211

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 as well. Now,…

2

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 Engine recovery handle failed. Check the SQL Server error log…

74