Hi,
We are using ASP.Net 2005 and SQL Server 2005. We are storing sessions in
the database. From time to time we get the following exception in the
application while the ASP.Net session tries accessing the database. This also
happens from time to time when our application is accessing the database. To
make the posting brief, I am just putting part of the exception.
Any ideas why this might be happening? Our web application is behind F5 load
balancers that does round-robin load balancing.
Thanks in advance for your help.
Sanjay
Exception information:
Exception type: SqlException
Exception message: A transport-level error has occurred when sending the
request to the server. (provider: TCP Provider, error: 0 - An existing
connection was forcibly closed by the remote host.)
Thread information:
Thread ID: 13
Thread account name: NJMGROUP\PAAWebSQLD_svc
Is impersonating: False
Stack trace: at
System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean
breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParserStateObject.ThrowEx ceptionAndWarning()
at System.Data.SqlClient.TdsParserStateObject.WriteSn i()
at System.Data.SqlClient.TdsParserStateObject.WritePa cket(Byte flushMode)
at System.Data.SqlClient.TdsParserStateObject.Execute Flush()
at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_Sql RPC[] rpcArray,
Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest,
TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior
behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at System.Web.SessionState.SqlSessionStateStore.DoGet (HttpContext
context, String id, Boolean getExclusive, Boolean& locked, TimeSpan& lockAge,
Object& lockId, SessionStateActions& actionFlags)