Forum Discussion
MS Excel Error: “The certificate chain was issued by an authority that is not trusted”
SergeiBaklanOnly I am facing the problem. Rest of my colleagues dont have such issue. Do yuo still think it's a problem from server or something is wrong with my excel or laptop?
Thank you
We can bypass certificate trust. We shouldn't. It is a security threat. As an IT exec, I would instruct my DBA to fix the problem at the server. But if you really want to bypass it and you are using a connection string in VBA you need to add the parameter TrustServerCertificate=true;
https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/connection-string-syntax#using-trustservercertificate
https://blog.greglow.com/2020/01/16/sql-sql-server-the-certificate-chain-was-issued-by-an-authority-that-is-not-trusted/
https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/connection-string-keywords-and-data-source-names-dsns?view=sql-server-ver15