TrustServerCertificate not working in sqlcompare cmd line 15.0.2+

nickheuperman

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.

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!  

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

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

nickheuperman

I can verify this issue has not been resolved in the latest version nor 15.0.5

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

nickheuperman

Jon_Kirkwood said:

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