Certificate chain issued by 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.
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.
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.