Comparing databases - Failed
SP2020
Posts: 1 New member
in SQL Compare
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)
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)
Tagged:
Answers
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.
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?
I know for fact that the acces used to work. I'm not sure if there was a change at the security level, or a port change.
Any other ideas where to look for the issue?
You no longer need to place ";Trust Server Certificate=true" in the connection string
We now have the toggle option, which you can see in the UI on your screenshot
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?
Thanks for pointing me out.