Remember that the “Cannot Generate SSPI context” problem described in this post only happens when connecting to a local server; thus, the “127.0.0.1” is applicable. If the connection string is prefixed with “tcp”, then you do need to modify your connection string to specify “127.0.0.1” as .
Cannot generate SSPI context (20) Other users not on the domain (for example, users who VPN to the network) but using domain credentials were able to successfully Failed to download the project from the server. Failed to open project database. The target principal name is incorrect. Cannot generate SSPI context. Now we decided to replace the service account to the new domain. When that change was done, Windows Authentication failed to work. SQL Server shows message "Cannot generate SSPI context". If I log in the server using MSTSC, Windows Authentication works. But if I try to log from my local PC, it fails. Cannot generate SSPI context. State ID: HY000. kriki Member, You can also VPN into your network and then connect. yes, but I don't always have internet. Sep 05, 2008 · Failed System.Data.SqlClient.SqlException: Cannot generate SSPI context It can happen when all of followings are true: (1) The hosting machine of SQL Server is connected to a network, including home network or dialup connection, but it is disconnected from its domain.
SQL Server / The target principal name is incorrect
Oct 17, 2013 Impossible de générer le contexte sspi [Résolu] - Comment
How to Fix SQL Server Management Studio SSMS SSPI Error
How to Fix SQL Server Management Studio SSMS SSPI Error Mar 09, 2017