How can we help you today? How can we help you today?

SQL Compare does not log in SQL Server

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
Mario
0

Comments

4 comments

Sort by
  • 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.
    Ben_P
    0
  • 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
    0
  • Mario
    Hi Again,

    got it! 



    Thanks!

    Kind regards,

    Mario

    Mario
    0
  • 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.
    Ben_P
    0

Add comment

Please sign in to leave a comment.