英文:
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
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论