SQL 2012 SP1 missing SSL Certificate. Refuses to run/Cannot add another one.

%3CLINGO-SUB%20id%3D%22lingo-sub-1296528%22%20slang%3D%22en-US%22%3ESQL%202012%20SP1%20missing%20SSL%20Certificate.%20Refuses%20to%20run%2FCannot%20add%20another%20one.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1296528%22%20slang%3D%22en-US%22%3E%3CP%3ESo%20upon%20initial%20installation%20of%20SQL%20Server%20on%20Server%202012%20Standard%2C%20it%20complained%20about%20the%20SSL%20Certificate%20and%20refused%20to%20start%20running.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUpon%20investigating%2C%20I%20see%20it%20did%20not%20have%20a%20SSL%20Certificate.%26nbsp%3B%20Using%20ISS%2C%20I%20created%20a%20self-signed%20one%20(personal)%2C%20and%20imported%20a%20wildcard%20one.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUsing%20MMC.exe%2C%20and%20the%20certificates%20snap-in%2C%26nbsp%3B%20I%20can%20see%20both%20certificates%20have%20been%20accepted%2C%20and%20available.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20in%20the%20SQL%20Server%20Configuration%20Manager%20-%26gt%3B%20Network%20Configuration%20-%26gt%3B%20Protocols%20for%20MSSQLSERVER%20-%26gt%3B%20Properties%20-%26gt%3B%20Certificate.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20only%20one%20showing%20up%20there%2C%20is%20the%20self-signed%20certificate.%20So%20I%20have%20no%20choice%20but%20to%20select%20that%20one.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20try%20starting%20SQL%20server%20again%2C%20yet%20another%20failure%20to%20start.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20a%20snippet%20of%20the%20log%20showing%20reason%20for%20failure.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2020-04-09%2011%3A49%3A47.37%20spid5s%20Server%20name%20is%20'WIN-PG8G8NTNTOO'.%20This%20is%20an%20informational%20message%20only.%20No%20user%20action%20is%20required.%3CBR%20%2F%3E2020-04-09%2011%3A49%3A47.39%20spid10s%20The%20server%20could%20not%20load%20the%20certificate%20it%20needs%20to%20initiate%20an%20SSL%20connection.%20It%20returned%20the%20following%20error%3A%200x8009030d.%20Check%20certificates%20to%20make%20sure%20they%20are%20valid.%3CBR%20%2F%3E2020-04-09%2011%3A49%3A47.39%20spid10s%20Error%3A%2026014%2C%20Severity%3A%2016%2C%20State%3A%201.%3CBR%20%2F%3E2020-04-09%2011%3A49%3A47.39%20spid10s%20Unable%20to%20load%20user-specified%20certificate%20%5BCert%20Hash(sha1)%20%2264D668546DC836E5391D23A9D05C721CEFB7F08F%22%5D.%20The%20server%20will%20not%20accept%20a%20connection.%20You%20should%20verify%20that%20the%20certificate%20is%20correctly%20installed.%20See%20%22Configuring%20Certificate%20for%20Use%20by%20SSL%22%20in%20Books%20Online.%3CBR%20%2F%3E2020-04-09%2011%3A49%3A47.39%20spid10s%20Error%3A%2017182%2C%20Severity%3A%2016%2C%20State%3A%201.%3CBR%20%2F%3E2020-04-09%2011%3A49%3A47.39%20spid10s%20TDSSNIClient%20initialization%20failed%20with%20error%200x80092004%2C%20status%20code%200x80.%20Reason%3A%20Unable%20to%20initialize%20SSL%20support.%20Cannot%20find%20object%20or%20property.%3CBR%20%2F%3E2020-04-09%2011%3A49%3A47.39%20spid10s%20Error%3A%2017182%2C%20Severity%3A%2016%2C%20State%3A%201.%3CBR%20%2F%3E2020-04-09%2011%3A49%3A47.39%20spid10s%20TDSSNIClient%20initialization%20failed%20with%20error%200x80092004%2C%20status%20code%200x1.%20Reason%3A%20Initialization%20failed%20with%20an%20infrastructure%20error.%20Check%20for%20previous%20errors.%20Cannot%20find%20object%20or%20property.%3CBR%20%2F%3E2020-04-09%2011%3A49%3A47.39%20spid10s%20Error%3A%2017826%2C%20Severity%3A%2018%2C%20State%3A%203.%3CBR%20%2F%3E2020-04-09%2011%3A49%3A47.39%20spid10s%20Could%20not%20start%20the%20network%20library%20because%20of%20an%20internal%20error%20in%20the%20network%20library.%20To%20determine%20the%20cause%2C%20review%20the%20errors%20immediately%20preceding%20this%20one%20in%20the%20error%20log.%3CBR%20%2F%3E2020-04-09%2011%3A49%3A47.39%20spid10s%20Error%3A%2017120%2C%20Severity%3A%2016%2C%20State%3A%201.%3CBR%20%2F%3E2020-04-09%2011%3A49%3A47.39%20spid10s%20SQL%20Server%20could%20not%20spawn%20FRunCommunicationsManager%20thread.%20Check%20the%20SQL%20Server%20error%20log%20and%20the%20Windows%20event%20logs%20for%20information%20about%20possible%20related%20problems.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%20on%20getting%20this%20resolved%3F%20Thank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

So upon initial installation of SQL Server on Server 2012 Standard, it complained about the SSL Certificate and refused to start running.

 

Upon investigating, I see it did not have a SSL Certificate.  Using ISS, I created a self-signed one (personal), and imported a wildcard one.

 

Using MMC.exe, and the certificates snap-in,  I can see both certificates have been accepted, and available.

 

Then in the SQL Server Configuration Manager -> Network Configuration -> Protocols for MSSQLSERVER -> Properties -> Certificate.

 

The only one showing up there, is the self-signed certificate. So I have no choice but to select that one. 

 

I try starting SQL server again, yet another failure to start.

 

Here is a snippet of the log showing reason for failure.

 

2020-04-09 11:49:47.37 spid5s Server name is 'WIN-PG8G8NTNTOO'. This is an informational message only. No user action is required.
2020-04-09 11:49:47.39 spid10s 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.
2020-04-09 11:49:47.39 spid10s Error: 26014, Severity: 16, State: 1.
2020-04-09 11:49:47.39 spid10s Unable to load user-specified certificate [Cert Hash(sha1) "64D668546DC836E5391D23A9D05C721CEFB7F08F"]. 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.
2020-04-09 11:49:47.39 spid10s Error: 17182, Severity: 16, State: 1.
2020-04-09 11:49:47.39 spid10s TDSSNIClient initialization failed with error 0x80092004, status code 0x80. Reason: Unable to initialize SSL support. Cannot find object or property.
2020-04-09 11:49:47.39 spid10s Error: 17182, Severity: 16, State: 1.
2020-04-09 11:49:47.39 spid10s 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.
2020-04-09 11:49:47.39 spid10s Error: 17826, Severity: 18, State: 3.
2020-04-09 11:49:47.39 spid10s 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.
2020-04-09 11:49:47.39 spid10s Error: 17120, Severity: 16, State: 1.
2020-04-09 11:49:47.39 spid10s SQL Server could not spawn FRunCommunicationsManager thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

 

Any ideas on getting this resolved? Thank you

0 Replies