The target principal name is incorrect The target principal name is incorrect

The target principal name is incorrect

If you receive the error message:

Microsoft.Data.SqlClient.SqlException: 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)

The most likely cause, when it occurs in SQL Source Control, is a certificate validation issue.

You can either fix the underlying certificate validation issue or you can work around the issue by following the instructions on this related article.