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.
"Rick" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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.
>
>
Similar Threads
