Table of Contents

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.