When connecting to SQL Server, you might encounter this login error:
“A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 – The certificate chain was issued by an authority that is not trusted.)”
This error stems from SQL Server using an SSL certificate that the client system doesn’t recognize or trust—common with self-signed certificates or those from private certificate authorities (CAs)
Quick Fix: Following are the steps to fix the error:
- Open SQL Server Management Studio.
- In the Connect to Server dialog, click Options > Connection Properties.
- Check the box for “Trust server certificate”
- Proceed to connect.
