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.

Sep 05, 2008 Sharepoint 2010: Cannot generate SSPI context | Mike Says Meh Cannot generate SSPI context. (Microsoft SQL Server, Error: 0) After reading a lot of blogs and KB’s I finally found the fix. Add the service account to the local administrators group on the SQL server running your config database. Learning about ASP tables, SPI and VPN contexts - TunnelsUP ASA# SHOW ASP TABLE VPN-CONTEXT DETAIL | begin 922FAC VPN CTX = 0x00922FAC Peer IP = 10.10.15.0 Pointer = 0xD91404E8 State = UP Flags = ENCR+ESP SA = 0x1664DD33 SPI = 0xE5C56C30 Group = 47 Pkts = 362631 Bad Pkts = 0 Bad SPI = 0 Spoof = 0 Bad Crypto = 0 Rekey Pkt = 44 Rekey Call = 44 VPN Filter = Above is the Context, SA and SPI of the Azure SQL Server VM cannot connect using Windows

Cannot generate SSPI context can mean exactly that. When a client connects to an SQL server it uses a generation method that includes the service type (MsSQLsvr) Server FQDN and port. It uses DNS to generate the server name so if it resolves the name incorrectly due to CNAMEs or host file etc the generation will fail.

Raison : Impossible de générer le contexte SSPI // J'ai bien vérifié que mon service manager est en marche. Donc le problème ne vient pas de là. Mes sources de données ODBC n'ont pas l'air d'avoir été modifiées non plus, donc le problème n'est pas là encore une fois. Par contre, et je me demande si cela peut avoir un rapport, ma How the Cannot generate SSPI context error was fixed | SQL Sep 05, 2011

SSPI cannot be generated when using VPN connection

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 Solutions | Experts Exchange As the title states, I am getting the "Cannot Generate SSPI context" errors when I try to connect to a remote SQL Server DB. My computer runs on DomainA, and the server I'm trying to connect to runs on DomainB, but I connect to DomainB via VPN before attempting the SQL logon. I am able to ping the server on DomainB by name and it resolves Cannot connect to SQL DB over PPTP VPN - Devolutions Forum The target principal name is incorrect. Cannot generate SSPI context. The SQL Connection settings uses the SQL server IP address. I have checked the SPN records and there are no duplicates. I can ping the SQL server and telnet to port 1433 fine while connected to the VPN. DNS records resolve the server fine (however the connection uses IP address). VPN & Cannot generate SSPI context. | TechTalkz.com