Forum Discussion
MS Excel Error: “The certificate chain was issued by an authority that is not trusted”
I am getting below error with Excel files which is retreving data from SQL Server. DataSource.Error:Microsoft SQL: A connection was successfully established with the server, but then an error oc...
Certificate could be not published on your machine, perhaps switching off encryption of the connection could help. In general yes, that's database administrator question.
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;
