March 1, 2016 by Nitesh

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

Friends,

Recently, I migrated a website hosted on Azure to a shared hosting server and started getting connectivity error for SQL server. The error was –

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

After some research, I found that the error occurs when we do not have a CA signed certificate installed in SQL database server’s trusted root store. In order to fix this issue, we can use “TrustServerCertificate=True” property in the connection string. The connection string will now look like following –


 

Hope this post helps you. If you’re aware of any other ways of resolving this issue, let me know via comments. Cheers!

#ASP.Net#SQL Server#Troubleshooting

Support us!

If you like this site please help and make click on any of these buttons!

Powered by WordPress Popup