Visual Studio 2022 SQL Compare 出现“目标主体名称不正确”错误。

huangapple go评论66阅读模式
英文:

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

问题

我们在Visual Studio中有一个SQL项目,最近从VS2019迁移到了VS2022。在2019年,我们的SCMP比较正常工作,但在2022年,我们遇到了以下错误:

> 与服务器成功建立了连接,但在登录过程中发生了错误。 (提供程序:SSL提供程序,错误:0 - 目标主体名称不正确。) (Microsoft SQL Server,错误:-2146893022)

我们使用集成安全性来保护数据库。

英文:

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.

答案1

得分: 2

由于某种原因,在使用UI时,无法保存我的高级设置。我直接编辑文件将连接字符串更改为TrustCertificate,现在可以正常工作。

英文:

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

huangapple
  • 本文由 发表于 2023年5月11日 02:59:00
  • 转载请务必保留本文链接:https://go.coder-hub.com/76221778.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定