A transport-level error has occurred when receiving results from the server [closed]

Question

I'm getting a SQL Server error:

A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The handle is invalid.)

I'm running Sql Server 2008 SP1, Windows 2008 Standard 64 bit.

It's a .Net 4.0 web application. It happens when a request is made to the server. It's intermittent. Any idea how I can resolve it?

Answer 1

The database connection is closed by the database server. The connection remains valid in the connection pool of your app; as a result, when you pickup the shared connection string and try to execute it's not able to reach the database. If you are developing Visual Studio, simply close the temporary web server on your task bar.

If it happens in production, resetting your application pool for your web site should recycle the connection pool.

Answer 2

Try the following command on the command prompt:

netsh interface tcp set global autotuning=disabled 

This turns off the auto scaling abilities of the network stack