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.