A transport-level error has occurred [duplicate]

This question already has answers here: Closed 10 years ago.

Possible Duplicate:

A transport-level error has occurred when receiving results f开发者_高级运维rom 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.

---

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.

---

Yes, I have a few times actually. Very very irratating error. If I'm not mistaken had something to do with Named Pipes instead of Shared Memory being used.

Please take a look at the following links should help you sort out the isse.

Link 1 Link 2