SQL Compare does not log in SQL Server

Mario

Hi RedGate Team,

currently I've a problem with SQL Compare. The following error message is thrown, when I try to connect to any of our SQL Server:




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 untrusted certificate authority.)

Other products like SQL Data Compare work fine with our SQL Servers. Please help!

Kind regards,

Mario

Ben_P

Hi Mario,

Looking at the error message that you are receiving you have a few options:
 

• disable encryption in your connection string ;encrypt=false
• allow trust of the cert in your connection string ;trustServerCertificate=true

 
SQL Compare now encrypts connections to SQL Server by default Previously, connections would have been encrypted according to the server's Force Encryption setting. This change came about in 14.8.0.21190.

Mario

Hi Ben,

thank you for your help. But I have a quick additional question... where should I edit the connection string? In the SQL Compare Tool?

Kind regards,
Mario

Mario

Hi Again,

got it! 



Thanks!

Kind regards,

Mario

Ben_P

Hi Mario,

Glad to hear you got that sorted. 

Also just to let you know, the dev team are working on an update for this process so that there are options in the UI to enable/disable encryption.