SQL SSMS Certificate Error

 SSMS Certificate Error KB ID 0001921

Problem

While attempting to open Microsoft SQL Server Management Studio (Version 21) I was met with this.

SQL SSMS Certificate Error

Encryption was enabled on this connection, review your SSL and certificate configuration for the target SQL Server, or enable ‘Trust server certificate’ in the connection dialog”

Additional Information

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.)” (Microsoft SQL Server)

The certificate chain was issued by an authority that is not trusted.

Solution : SQL SSMS Certificate Error

Well is self-explanatory, the server has a self-signed certificate on it (that’s completely normal). The correct way to fix this error is to put a certificate on the server that is trusted. However this was a stand-alone SQL server on my test network I was just running up to do some testing. 

You can bypass this error by simply clicking the advanced tab on the connection screen and changing “Trust Server Certificate” to True.

SQL SSMS Certificate Error

Before everyone emails me, yes YOU SHOULD NOT do this on a production server, either purchase a publicly signed SSL cert or deploy your own PKI environment.

Related Articles, References, Credits, or External Links

The certificate received from the remote server was issued by an untrusted certificate authority” error when you connect to SQL Server

Author: PeteLong

Share This Post On

Submit a Comment

Your email address will not be published. Required fields are marked *