468,765 Members | 1,499 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,765 developers. It's quick & easy.

Data access error

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.GetConne ction(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter.FillInternal(Data Set 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(Str ing 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.
Oct 5 '07 #1
4 3904
How to troubleshoot the "Cannot generate SSPI context" error message
http://support.microsoft.com/kb/811889


"Rick" <rf*****@newsgroups.nospamwrote in message
news:%2****************@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.GetConne ction(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter.FillInternal(Data Set 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(Str ing 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.


Oct 5 '07 #2
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.GetConne ction(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter.FillInternal(Data Set 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(Str ing 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.

"Rick" <rf*****@newsgroups.nospamwrote in message
news:%2****************@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.GetConne ction(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter.FillInternal(Data Set 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(Str ing 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.


Oct 8 '07 #3
On Oct 8, 7:51 pm, "Rick" <rfem...@newsgroups.nospamwrote:
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

Oct 8 '07 #4
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.

"Rick" <rf*****@newsgroups.nospamwrote in message
news:eY**************@TK2MSFTNGP03.phx.gbl...
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.GetConne ction(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter.FillInternal(Data Set 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(Str ing 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.

"Rick" <rf*****@newsgroups.nospamwrote in message
news:%2****************@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.GetConn ection(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.GetC onnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenC onnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter.FillInternal(Data Set 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(Str ing 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.



Oct 10 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

32 posts views Thread by Neil Ginsberg | last post: by
1 post views Thread by Andrew Arace | last post: by
3 posts views Thread by developer | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by Marin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.