SSMS Certificate Error KB ID 0001921
Problem
While attempting to open Microsoft SQL Server Management Studio (Version 21) I was met with this.
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.
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.
