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

TrustServerCertificate not working in sqlcompare cmd line 15.0.2+

Connecting to a server through setting /server2:"{omitted},1433;TrustServerCertificate=true;Encrypt=true" no longer works in cli versions 15.0.2 and up, server certificate validation fails.

Doing the exact same (arguments) on version 15.0.0 and lower succesfully compares databases.

Interestingly enough, using a .scp file to supply the arguments and omitting any datasource2 options does make 15.0.2+ work.
nickheuperman
0

Comments

6 comments

  • Robyn
    Hi, 

    Thanks for your post.

    Please could I ask what the error is your are getting? That is, presuming an error is shown. And also, what interface (CMD, Powershell etc) you are using? 

    I hope we can shed some light on this!
    Robyn
    0
  • nickheuperman
    Powershell on windows: Certificate has expired (which it hasn't, although the ca is not trusted)
    On ubuntu (bash with dotnet /app/SQLCompare.dll) it gives a more generic error about the pre-login handshake failing after succesfully connecting
    nickheuperman
    0
  • Jon_Kirkwood
    Hi nuckheuperman,

    Are you able to patch into v15.0.5 at your earliest convenience and verify if this issue has been resolved

    Download link available here:
    https://download.red-gate.com/checkforupdates/SQLCompare/SQLCompare_15.0.5.23181.exe
    Jon_Kirkwood
    0
  • nickheuperman
    I can verify this issue has not been resolved in the latest version nor 15.0.5
    nickheuperman
    0
  • ajj
    Issue confirmed once again
    Could not connect to azure sql managed instance using an sql username and password
    Once I specified 15.0.0 the error went away
    ajj
    0
  • nickheuperman
    Hi nuckheuperman,

    Are you able to patch into v15.0.5 at your earliest convenience and verify if this issue has been resolved

    Download link available here:
    https://download.red-gate.com/checkforupdates/SQLCompare/SQLCompare_15.0.5.23181.exe
    Can this be looked into? The current working version (linux beta) will expire the 17th of this month
    nickheuperman
    0

Add comment

Please sign in to leave a comment.