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. 4 4127
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.
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.
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
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.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Jack |
last post by:
Hi,
I am trying to test a sql statement in Access which gives me
the error as stated in the heading.
The sql statement is built as a part of asp login verification,
where the userid and password...
|
by: Neil Ginsberg |
last post by:
We're using SQL Server 7 with an Access 2000 MDB as a front end with ODBC
linked tables. I recently created a new set of tables for the app, and users
are complaining that unsaved data is being...
|
by: Dan |
last post by:
Could someone please help me with auto importing a series of data
files into an Access table. I tried to follow code given below in a
previous messagebut i'm getting error messages.
Here's my...
|
by: Christopher Koh |
last post by:
how do you stop Access from saving any changed data in your tables and
queries?
like i just add or change data on the table/query tables,then click on
X (exit)because i have no intention of saving...
|
by: Andrew Arace |
last post by:
I scoured the groups for some hands on code to perform the menial task
of exporting table data from an Access 2000 database to Oracle
database (in this case, it was oracle 8i but i'm assuming this...
|
by: Jerry |
last post by:
I have an off-the-shelf app that uses an Access database as its
backend. One of the tables contains a field with an "OLE Object"
datatype. I'm writing some reports against this database, and I...
|
by: Brian Foree |
last post by:
I am developing an ASP.NET application that uses Access 2000 as its backend,
and have just started getting the following error on 2 ASP.NET pages that
had been working until late last week (and I...
|
by: developer |
last post by:
Hi All,
I am lil confused with different ways of asynchronous data access.
My understanding is that, asynchronous data access frees up a thread
instead of engaging it while a stored proc is...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |