Visual Studio for Mac connection to remote MS SQL Server failed

entity-framework-core sql-server visual-studio-mac

Question

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.

The connection string: Server=MySQLServer.domain.de;Database=MyDatabase;User Id=sa;Password=***;

Any ideas? Thanks a lot.

1
2
5/20/2017 7:27:46 PM

Accepted Answer

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

0
6/1/2017 9:36:05 AM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow