A transport-level error has occurred… (Existing connection closed by the server) Sql Server 2008

sql-server-2008

I have a web application which is currently running on Windows XP operating system with SQL Server 2005 database and IIS 6.0.

Now, we are trying to upgrade it to IIS 7.0 on Windows Server 2008 and SQL server 2008 database.

When I run the application then it is throwing "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.)" randomly at different database calls.

I have verified using "sp_who" that only one connection which I am using is opened.

Can anyone tell me, what could be the cause of this issue?

Best Solution

This blog post by Michael Aspengren explains the error message "A transport-level error has occurred when sending the request to the server."

Related Question