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

Recently we moved whole on-premises resources to the cloud. In an easy word, we have moved SQL Server from on-premises to Azure cloud as IaaS.

Now few users ran into this confusing error while connecting the databases.

Error Message:
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

After a couple of google searches, I come to know that issue is regarding Trusted Certificate Authorities (CA) in SSMS. For further knowledge, you may google, but as of now let’s concentrated on resolution.

Resolution:
Nothing to do on SQL Server. We need to check the SSMS from where we are connecting to the database server. Simply Go to the “Connect to Server” option pop-up window >> Options >> Check “Trust server certificate“. After selection, SSMS will accept the remote certificate and complete the connection.

 

Facebook Comments Box
Please like or share this post if you found it helpful, thank you.
Share on Facebook
Facebook
0Tweet about this on Twitter
Twitter
Share on LinkedIn
Linkedin
Email this to someone
email
Print this page
Print

Comments

Leave a Reply

Your email address will not be published.