We have a custom web part based on a user control that queries a database cluster. When the connection to the database is made, we regularly experience the error below and have had to create a work-around in the code to retry the connection. We have
3 environments - development, staging and production; the error only occurs in production. The difference in the production environment is it is a farm with 3 WFEs and a SQL cluster, where development and staging are single machine instances.
All are MOSS 2007 & SQL Server 2008.
We cannot find what is causing this issue and I'm hoping someone else has experienced a similar problem and knows the cause.
This is the error that occurs frequently when the query is executed:
System.Data.SqlClient.SqlException: 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.)
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
View Complete Post