A transport-level error has occurred [duplicate]

Question

Possible Duplicate:
A transport-level error has occurred when receiving results from the server

A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

We are getting the following error message appearing intermittently on our server. We are running a asp.net 4 web application with SQL Server 2008 database. Has anyone ever come across this error message and a solution to stop this happening.

The strange thing is this issue was not occurring on our dev system and we are finding it very difficult to replicate due to the sporadic nature of this issue.

Still have not found a solution to this issue.

Answer 1

As the error message indicates, there is a connectivity problem with a previously opened session in SQL Server.

Try:

SqlConnection.ClearAllPools(); 

---

SqlConnection.ClearAllPools Method resets (or empties) the connection pool. If there are connections in use at the time of the call, they are marked appropriately and will be discarded (instead of being returned to the pool) when Close is called on them.