Fail to start MSSQLSERVER 2016 service after windows server 2016 patch

Question

Last night there is windows server 2016 patch installed, and then we found the mssqlserver 2016 service failed with error.

Now we have rollbacked the windows patch KB5012596, but the mssqlserver 2016 service still failed to start with bellow error:
Unable to load user-specified certificate [Cert Hash(sha1) "19A4C4FD63C459C802DC7FEBA8A0854CDF04EC2E"]. 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.

Please kindly guide how to recover the service quickly. Many thanks!

Attachments:

1. windows server 2016 patch:

2) MSSQLSERVER 2016 service failure error.

3) Sql configuration management;

Answer 1

I googled on "TDSSNIClient initialization failed with error 0x80092004, status code 0x80" and "Cannot find object or property." and found these links that may help you:

https://learn.microsoft.com/en-us/troubleshoot/sql/security/service-cannot-start
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/63c15cb5-0d12-4ea8-bf84-e3ea8a42a866/regarding-the-sql-server-service-starting-problem?forum=sqldatabaseengine

Answer 2

My gut feeling is that this is a matter of registry corruption. The Windows patch is unlikely to have anything do with it - except that you had to restart the machine, whereupon the corruption started to hurt.

I should immediately repeat that this is just gut feeling - or a guess, if you like. So don't run away to take actions based on this.

One thing that would help would be to see the SQL Server errorlog. There can be errors there leading up to the final errors that can give more information.

Answer 3

@Erland: Thank you so much for your reply.
I tried to start the MSSQLSERVER service and see the all error event logs as bellow, please kindly give your guide how to fix it. Many appreciations!

Answer 4

@Erland: Thank you. I have viewed SQL Server error log, and there are bellow error log files after patching of windows server 2016 ; obviously the problem still exists after rollbacking the patch.
Please kindly guide how to fix it. Many appreciations!
193592-sqlagent.txt193593-errorlog6.txt

Answer 5

@Erland: Thank you so much. I checked the property in SQL Server Configuration Manager, the certificate is empty.

And I have chosen the server self-signed certificate to apply it and then restart still with error, the SQL Server error log is as bellows:
193490-errorlog4.txt

It seems that the certificate still has problem, please kindly guide it. Many appreciations!