SSL Provider error when starting SQL Server
Error Message
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. ) provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) (Microsoft SQL Server)
Explanation of Error
Option for Force Protocol Encryption was selected in the SQL Client Configuration utility. If that option is enabled, SQL Server looks for an authenticated security token first before starting the SQL Service in Windows.
Severity
High
Possible Root Cause(s)
Option for Force Protocol Encryption was selected in the SQL Client Configuration utility.
Resolution
1. Click on Start, then click on Run.
2. Type cliconfg.exe and press Enter.
3. Uncheck “Force protocol encryption” option.
4. Restart server machine.