SQL Server not starting - FallBack certificate initialization failed

Question

I can not start my SqlServer 2008 Express. The problem seemed to start when I changed my "Built In account, Log in as" from Local Service to Local System. If I try to change back to Local Service I get the messagebox with WMI Provider Error, "Cannot find object or property. [0x80092004]".

Getting a bit confused, but read http://support.microsoft.com/kb/900497    mentioned about 

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib, Value name: Certificate, Type: REG_SZ not having a valid value then 2005 would not starte - my value is blank. Changing it to 0 did not work.

How can I import a valid certificate using SQL Server Configuration Manager. And how do you turn off Forced Encryption? Not sure if this would fix it, but couldn't hurt.

======================================

2009-03-08 01:39:06.01 Server      Error: 17190, Severity: 16, State: 1.
2009-03-08 01:39:06.01 Server      FallBack certificate initialization failed with error code: 1.
2009-03-08 01:39:06.01 Server      Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.
2009-03-08 01:39:06.01 Server      Error: 17182, Severity: 16, State: 1.
2009-03-08 01:39:06.01 Server      TDSSNIClient initialization failed with error 0x80092004, status code 0x80. Reason: Unable to initialize SSL support. Cannot find object or property.

2009-03-08 01:39:06.01 Server      Error: 17182, Severity: 16, State: 1.
2009-03-08 01:39:06.01 Server      TDSSNIClient initialization failed with error 0x80092004, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. Cannot find object or property.

2009-03-08 01:39:06.01 Server      Error: 17826, Severity: 18, State: 3.
2009-03-08 01:39:06.01 Server      Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
2009-03-08 01:39:06.01 Server      Error: 17120, Severity: 16, State: 1.
2009-03-08 01:39:06.01 Server      SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
2009-03-08 01:39:06.07 spid14s     Clearing tempdb database.

=====================================

Any help would be appreciated.

TheBrenda

Answer 1

I have set the Network Force Encryption = NO. And there are no certificates listed on the CERTIFICATE tab.

Maybe this started when I deleted SQL server 2005? Maybe it took the only certificate?

Answer 2

Which OS are you using, is it XP? There is a problem with XP LocalService account and SQL Server initialization. If that is the case then change it to either NetworkService or some other user account (using SQL configuration manager) and then try to start it. If you are not running XP then let us know.

Also look at the thread: http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/cd4cbc1d-3e0e-4a54-9e8f-f9df5b669992/#page:2

---

Zubair

Answer 3

I think this may be the answerto this crazy error:FallBack certificate initialization failed with error code: 1.

I too wanted to change the 'Log on as'' account from NT AUTHORITY\NETWORK SERVICE to 'Local Service' primarialy because my 'filestream' service had 'NT AUTHORITY\LOCAL SERVICE' after reinstalling SQL Server Express 2008 SP1 w/Advance Services, and I wanted to see if this would solve my AW install problems. (I'll explain this in another down the road.) This is where the trouble commenced. I tirelessly googled up and down the Net trying to find a solution for this problem to no avail. Every link I followed was telling me to do all of my alterations w/SSCM. After soo many furstrations and DEAD-ENDS, I went back to my old problem solving skills and tried to evaluate where else in the past had I manipulated SQL Services for my SQL 2000 environment. The $64,000 answer was of all places in  the home of 'SERVICES!' I took a look at mytrusted system Services appl. where all services for my machine runs and looked at the 'Log on' and found that the optional button for 'This account' had been selected with 'NT AUTHORITY\NETWORK SERVICES' were set for this instance. My option was to select the top Local Services button, going to the general tab and selecting the 'start' services & I was back in business!!!

I waited a few seconds to see if SSCM would be reflective of the change, but NO :() luck!? I next called on some courage to right-click the SQLServerExp2008 line in SSCM & chose the start button. VOWLA . . . Success everything was back in sync again.  I am sure interested in knowing how these to apps got out of sync, but that resolution will have to wait for a while.


Hope this helps someone else out there.
TomJ

---

Tom Johnson

Answer 4

I would just like to say a massive thanks Tom - you saved my day!!!!!

Answer 5

I had exact the same problem and error log.

Trouble was the SPN (Service Principal Name) we had set on the SQL service account. We made a typo in de server name. When we corrected the SPN, all SQL services started ... Hope this can help anyone.

 

Answer 6

You saved my day too..... Thanks 

Answer 7

I think I'm in love...

Answer 8

I had the same problem. Tried to change the 'Log On As' for the sql server service to Local System, but it didn't work.

The following *did* actually work:

• run the downloaded installer
• it extracts files in c:\some-weird-hexadecimal-name
• copy all files in that folder to somewhere else
• close the installer (files in c:\some-weird-name are gone)
• run a command prompt as administrator, and cd to the folder where the copy of the files are
• then run

setup /action=RebuildDatabase /InstanceName=SQLEXPRESS /SqlSysAdminAccounts=BUILTIN\Administrators

Done.