Visual Studio for Mac连接到远程MS SQL Server失败 [英] Visual Studio for Mac connection to remote MS SQL Server failed

问题描述

我正在通过Microsoft EntityframeworkCore在macOS Sierra上使用Visual Studio for Mac 2017，并且试图连接到远程MS SQL Server。
如果我在Windows计算机上的Visual Studio中启动项目，则一切正常。但是，当我尝试从SQL Server获取数据时，Mac上的同一项目告诉我对SSPI的调用失败。我可以使用Mac上的 Oracle SQL Developer工具连接到SQL Server。因此，问题出在Visual Studio中。

I'm using Visual Studio for Mac 2017 on macOS Sierra with Microsoft EntityframeworkCore and I'm trying to connect to a remote MS SQL Server. If I start the project in Visual Studio on my Windows machine, everything works fine. But the same project on my Mac tells me "A call to SSPI failed" when I try to get data from the SQL Server. I can connect to the SQL Server using the "Oracle SQL Developer" tool on my Mac. So the issue is somewhere in Visual Studio.

连接字符串： Server = MySQLServer.domain.de; Database = MyDatabase; User Id = sa ; Password = ***;

有什么想法吗？非常感谢。

Any ideas? Thanks a lot.

推荐答案

知道了。我必须将MS SQL Server 2008 R2 SP1更新到Service Pack3。否则，.Net Core无法连接： https://github.com/Microsoft/vscode-mssql/issues/666

Got it. I have to update my MS SQL Server 2008 R2 SP1 to Service Pack 3. Otherwise .Net Core cannot connect: https://github.com/Microsoft/vscode-mssql/issues/666

这篇关于Visual Studio for Mac连接到远程MS SQL Server失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！