Troubleshooting Certificates

Various issues may occur while enabling SSL encryption.

Certificate Is Not Available

For more information on resolving this issue, see the Troubleshooting section on the Microsoft® website: https://support.microsoft.com/en-us/kb/316898.

SQL Service Does Not Start after Enabling SSL Encryption

The following error messages may be written to the SQL Server Error log file:
  • DateTime Server 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.
  • DateTime Server Error: 17182, Severity: 16, State: 1.
  • DateTime Server TDSSNIClient initialization failed with error 0x80092004, status code 0x80.
  • DateTime Server Error: 17182, Severity: 16, State: 1.
Check to ensure that:
  • The certificate itself is valid and has not expired.
  • The certificate hash matches the certificate associated with the instance, but it was not loading.
For more information on resolving this issue, review the following websites: