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.
Answers:
Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.
Method 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.
Method 2
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.
All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0