sql schema compare connectivity issue

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 

Best Answer

  • RobynRobyn Posts: 142 Silver 4

    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. 
    Kind regards

    Robyn Edwards | Redgate Software
    Have you visited our Help Center?


Sign In or Register to comment.