SQL connectivity error

[Former Member]

Hi All,

I am getting error 'Cannot generated SSPI Context' while connecting from SQL Server Management Studio.

I can able to login after sometime and other time it shows the above error.

Log information as below :

Cannot generate SSPI context. (.Net SqlClient Data Provider)

-

---

For help, click: http://go.microsoft.com/fwlink?ProdName=MicrosoftSQLServer&EvtSrc=MSSQLServer&EvtID=0&LinkId=20476

-

---

Server Name: DBGRP

Error Number: 0

Severity: 11

State: 0

Procedure: GenClientContext

-

---

Program Location:

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.SSPIError(String error, String procedure)

at System.Data.SqlClient.TdsParser.SNISSPIData(Byte[] receivedBuff, UInt32 receivedLength, Byte[] sendBuff, UInt32& sendLength)

at System.Data.SqlClient.TdsParser.TdsLogin(SqlLogin rec)

at System.Data.SqlClient.SqlInternalConnectionTds.Login(Int64 timerExpire, String newPassword)

at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)

at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)

at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)

at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

at System.Data.SqlClient.SqlConnection.Open()

at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)

at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

Thanks in advance

Regards

Praveen

[Former Member]

Are you running SQL management studio on your own PC (not on the server ?)

You may try to add the SQL server's IP and hostname in your PC's hosts file (c:\windows\system32\drivers\etc\hosts) and see if this help.

Diana

[Former Member]

Hi,

I am opening on Server only

[markus_doehr2]

Is this Windows 2003 or Windows 2008?

As which user do you try to start?

Markus

[Former Member]

It windows 2003 Enterprise Edition.(It is on cluster)

It is working some time and shows the error some other time.

Regards

Shripad