Microsoft – SQL Server – Error – Startup Error – Unable to load user-specified certificate (0x8009030d / 0x80092004

 

 

SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
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.
TDSSNIClient initialization failed with error 0x80092004, status code 0x1.
TDSSNIClient initialization failed with error 0x80092004, status code 0x80.
The server could not load the certificate it needs to initiate an SSL connection. It returned the following error: 0x8009030d. Check certificates to make sure they are valid.
Unable to load user-specified certificate. The server will not accept a connection. You should verify that the certificate is correctly installed. See "Configuring Certificate for Use by SSL" in Books Online.
The SQL Server (MSSQLSERVER) service terminated with service-specific error 2148081668 (0x80092004).

The error messages listed above are due to in-correct permissions on SSL Certificates for the MS SQL Server Account.

If on MS Windows 2003, then use:

“X.509 Certificate Tool”
http://msdn.microsoft.com/en-us/library/aa529278.aspx

to assign permissions on certificate to MS SQL Server Start-up Account

If on MS Windows 2008 and above, then use:

MMC Certificate to assign permissions

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s