SQL Compare fails to connect when using AD password authentication

jaults

Hiya,

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?

Russell D

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).

PeteSilvester

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.