SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Networkname no longer available message.


Networkname no longer available message.

Author
Message
rocco_46902
rocco_46902
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 18
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.

SELECT
DB_NAME(dbid) as DBName,
COUNT(dbid) as NumberOfConnections,
loginame as LoginName
FROM
sys.sysprocesses
WHERE
dbid > 0
GROUP BY
dbid, loginame

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.
Joy Smith San
Joy Smith San
Hall of Fame
Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)

Group: General Forum Members
Points: 3162 Visits: 3200
Did you check it from network point of view ?. I think the server had gone out of network, may be.
rocco_46902
rocco_46902
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 18
When this happens we can ping the DB server from the same box getting the errors through IIS. We can execute a DB call external to IIS. We just can't make db calls within IIS. We put a call to SqlConnection.ClearAllPools() in based on some reading we have done but that does not seem to have an affect on the error.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search