Comments
2 comments
-
The most likely cause of this is that you likely don't have a CA signed certificate installed in your SQL machines trusted root store.
You can bypass it if you don't need one: https://stackoverflow.com/questions/17615260/the-certificate-chain-was-issued-by-an-authority-that-is-not-trusted-when-conn (at your own risk, obviously).
-
Just to add (since it wasn't made immediately obvious to me how to edit the connection string) you can add in ";TrustServerCertificate=True" after the server name in the "Server" field in the SQL Compare project dialog.
Add comment
Please sign in to leave a comment.
When I try to connect to a DB using AD password authentication mode from SQL Compare Pro 14, I get this error:
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.)
Any idea why?