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.

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.