How to fix; System.ComponentModel.Win32Exception: The certificate chain was issued by an authority that is not trusted

Question

This error is popping up when trying to connect to a site with an app. It is trying to connect to a SQL database. We tried adding trustecertificate=true to the connection string. This works for a bit but reverts the changes after a bit. What can we do to get this fixed?

Answer 1

Hi @Kenneth Fromm ,

Please refer to this document: https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/certificate-chain-not-trusted?tabs=ole-db-driver-19

Hope this would give you some help.

If the issue persists, you may need to configure the SQL Server to use a different SSL certificate that is issued by a trusted CA. This will require generating a new SSL certificate, importing it into the certificate store on the SQL Server, and updating the SSL settings for the SQL Server instance.

Best regards,

Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 2

The best way may be to install a trusted certificate. Here is an article that I have found useful when I need to do this: https://codekabinett.com/rdumps.php?Lang=2&targetDoc=create-install-ssl-tls-certificate-sql-server

Answer 3

Yes, any change I make in the web.config file for the connection it reverts back not long after. I am wondering if the user who is pushing any data towards the IIS instance on the server for the application is doing the change back.