Data access error

[Rick]

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.

 

[sloan]

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

 

[Rick]

In the line within the error where it says:
C:\$\Digecenter\PSXSTL.Data\DataAccess.vb:line 307. This is the directory
that the project file is referencing the dll that accesses the database, but
this is not where the file exists within the Project bin folder after the
web site is published, is this where the web site is actually trying to
access the dll from? Shouldn't it just be accessing the dll from it's own
bin folder?

I'm getting this error:

Event Type: Error
Event Source: PSXSTL.Data.DataAccess.SQLServer
Event Category: None
Event ID: 55
Date: 10/8/2007
Time: 12:29:05 PM
User: N/A
Computer: SERVERNAMEHERE
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) in C:\$\Digecenter\PSXSTL.Data\DataAccess.vb:line 307
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.

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.

 

[Guest]

In the line within the error where it says:
C:\$\Digecenter\PSXSTL.Data\DataAccess.vb:line 307. This is the directory
that the project file is referencing the dll that accesses the database, but

It referenced to the module where an error occured

Have you already checked the following links?

http://support.microsoft.com/kb/814401
http://support.microsoft.com/kb/811889

 

[Rick]

Turned out to be Access Permissions to registry keys.
Discover this by looking at Security in the Event Viewer and seeing alot of
Audit Failures with Object Access.

In the line within the error where it says:
C:\$\Digecenter\PSXSTL.Data\DataAccess.vb:line 307. This is the directory
that the project file is referencing the dll that accesses the database,
but this is not where the file exists within the Project bin folder after
the web site is published, is this where the web site is actually trying
to access the dll from? Shouldn't it just be accessing the dll from it's
own bin folder?

I'm getting this error:

Event Type: Error
Event Source: PSXSTL.Data.DataAccess.SQLServer
Event Category: None
Event ID: 55
Date: 10/8/2007
Time: 12:29:05 PM
User: N/A
Computer: SERVERNAMEHERE
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) in C:\$\Digecenter\PSXSTL.Data\DataAccess.vb:line 307
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.

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.