We have been receiving many of these lately. Sql Server 2008.
(provider: TCP Provider, error: 0 - The specified network name is no longer available.)
When it happens we have used sp_who to see if there were any connections from the web server and are not seeing more than a couple. I have saw that one of the possible causes can be connections not closed. We are not seeing any large numbers of connections. We have also run sql against sysprocesses.
DB_NAME(dbid) as DBName,
COUNT(dbid) as NumberOfConnections,
loginame as LoginName
dbid > 0
There is a close connection in every finally statement.
Same thing not seeing more than a few connections (less than 8). When the error happens every sql command fails. We have tried code to run through the connection pool and close all the connections that doesn't seem to work either. If I close the application pool in IIS for a period of time it will clear up. If we just restart IIS or the pool the error persists. Any ideas on where else we can look to try to resolve this?
Our setup for Sql Server is defaults mostly.