Date parsed: 05/10/2007 10:41:18
Date: Fri, 5 Oct 2007 14:41:18 -0400

How to troubleshoot the "Cannot generate SSPI context" error message
http://support.microsoft.com/kb/811889




"Rick" <rfemmer@newsgroups.nospam> wrote in message
news:%23bEr3b3BIHA.1056@TK2MSFTNGP03.phx.gbl...
> I've moved code from a stage machine to the production machine, exact same
> code works fine on the stage machine, they are both windows 2003 servers,
> I'm getting a "Cannot generate SSPI context" error, there are other sites
> on this server that access the same database. IIS is the same,
> permissions to the database are correct.
>
> Any suggestions?
>
> Error:
>
> Event Type: Error
> Event Source: PSXSTL.Data.DataAccess.SQLServer
> Event Category: None
> Event ID: 55
> Date: 10/5/2007
> Time: 12:32:00 PM
> User: N/A
> Computer: WEB2
> Description:
> An error occured in the following module: PSXSTL.Data.DataAccess.SQLServer
> The Source was: .Net SqlClient Data Provider
> With the Message: Cannot generate SSPI context.
> Stack Tace: at
> System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
> owningObject)
> 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 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
> DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
> srcTable, IDbCommand command, CommandBehavior behavior)
> at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
> startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
> CommandBehavior behavior)
> at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
> at PSXSTL.Data.DataAccess.SQLServer.runSQLDataSet(String SQL, String
> TableName)
> Target Site: Void OnError(System.Data.SqlClient.SqlException, Boolean)
>
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
>