CODEWITHSUNDEEP
sql-servervisual-studio-2022
Lance
Lance

Reputation: 611

Visual Studio 2022 SQL Compare giving The target principal name is incorrect error

We have a SQL project in Visual Studio and recently moved from VS2019 to VS2022. In 2019 our SCMP compare works fine but in 2022 we get the error:

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.) (Microsoft SQL Server, Error: -2146893022)

We use integrated security for database security.

Upvotes: 1

Views: 908

Answers (1)

Lance
Lance

Reputation: 611

For some reason when using the UI, it wouldn't save my advanced settings. I edited the file directly to change the connection string to TrustCertificate and it works now

Upvotes: 2

Related Questions