{"id":162,"date":"2012-04-23T07:43:07","date_gmt":"2012-04-23T07:43:07","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2012\/04\/23\/sql-server-cannot-generate-sspi-context\/"},"modified":"2012-04-23T07:43:07","modified_gmt":"2012-04-23T07:43:07","slug":"sql-server-cannot-generate-sspi-context","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2012\/04\/23\/sql-server-cannot-generate-sspi-context\/","title":{"rendered":"sql server cannot generate sspi context"},"content":{"rendered":"

fix for the error microsoft sql server cannot generate sspi context<\/strong><\/p>\n

1- Check if the system is up in the network. Telnet\/Ping the server.
\n2- Check if the date\/time match between the server and the client machines.
\n3- Change the service account of sqlserver and check if the error is resolved.
\n4- Refresh the dns on the client.
\n5- Check windows event log for advanced details of the error<\/p>\n

Below links give additional details:<\/p>\n

http:\/\/support.microsoft.com\/kb\/811889<\/a><\/p>\n

http:\/\/support.microsoft.com\/kb\/319723<\/a><\/p>\n

[xml]
\n===================================<\/p>\n

Cannot connect to server name.<\/p>\n

===================================<\/p>\n

Cannot generate SSPI context. (.Net SqlClient Data Provider)<\/p>\n

——————————
\nFor help, click: http:\/\/go.microsoft.com\/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=0&LinkId=20476<\/p>\n

——————————
\nServer Name: server name
\nError Number: 0
\nSeverity: 11
\nState: 0
\nProcedure: GenClientContext<\/p>\n

——————————
\nProgram Location:<\/p>\n

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
\n at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
\n at System.Data.SqlClient.TdsParser.SSPIError(String error, String procedure)
\n at System.Data.SqlClient.TdsParser.SNISSPIData(Byte[] receivedBuff, UInt32 receivedLength, Byte[] sendBuff, UInt32& sendLength)
\n at System.Data.SqlClient.TdsParser.ProcessSSPI(Int32 receivedLength)
\n at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
\n at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
\n at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
\n at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
\n at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
\n at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
\n at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
\n at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
\n at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
\n at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
\n at System.Data.SqlClient.SqlConnection.Open()
\n at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectorThread()
\n[\/xml]<\/p>\n","protected":false},"excerpt":{"rendered":"

fix for the error microsoft sql server cannot generate sspi context 1- Check if the system is up in the network. Telnet\/Ping the server. 2- Check if the date\/time match between the server and the client machines. 3- Change the service account of sqlserver and check if the error is resolved. 4- Refresh the dns…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[128],"tags":[1676,1677,1678,1679,1680,1681,1682,1683,1684,1685,1686,1687,1688,1689,1690],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/162"}],"collection":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/comments?post=162"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/162\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=162"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=162"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=162"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}