Comparing databases - Failed

SP2020

I am getting failure to register source and destination databases when running SQL Compare. Database server is SQL server 2019.
Message details are:
"A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - the target principal name is incorrect)

DanC

Hi @SP2020

So this was a recent change due to the update on the Microsoft Data Connection client.

You can workaround this by adding ";Trust Server Certificate=true" to the end of the server name in the connection dialog.