sql schema compare connectivity issue

jayman

i having an issue connecting to a server in sql compare

the certificate chain was issued by an authority that is not trusted

the server is on a different domain but i have it registered in windows credential manager and i have no issue connecting to both source and target in SSMS so its almost as if SQ compare isnt seeing or using credential manager 

Robyn

Hi, 

Thanks for your post. 

This error is likely due to recent changes around handling certificates and you can hopefully workaround this by adding ";Trust Server Certificate=true" to the end of the server name in the connection dialog.

If the above doesn't work. I'll raise you a ticket and we'll look again. 

jayman

that worked thank you