Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Named Pipes Stops Working After Some Time Expand / Collapse
Author
Message
Posted Tuesday, August 7, 2012 8:24 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, May 7, 2014 1:53 PM
Points: 72, Visits: 289
Hi All,

I have a SQL 2005 x64 Std Ed instance that allows TCP and Named Pipe connections. After restarting the server or the service, named pipes and TCP connections work. After an indeterminate amount of time, named pipes will stop accepting connections even though TCP connections still work perfectly fine. My only clue that named pipes is not accepting connections is that SQL jobs do not run. After I restart the SQL service, all returns to normal.

I've tried googling up some info but almost everything focuses on troubleshooting the complete lack of named pipes connectivity. I've only seen a couple of other [extremely short] threads describing the same issue without resolution.

For that reason, I won't ask if others have seen similar behavior behavior (it seems unlikely but if you can relate what fix worked for you that would be great!) but instead ask for ideas about how to isolate and troubleshoot.

1. Is it possible to exhaust named pipe connections?
2. Are there tools that show named pipe connections in the same way that tools for viewing TCP connections do?
3. There is nothing in the log file to help diagnose what is going on; is there something I can turn to start logging some info that could be of further assistance in troubleshooting?

TIA
Post #1341296
Posted Thursday, March 21, 2013 2:25 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 6:13 AM
Points: 25, Visits: 72
Hi
Have the same problem, but with SQL 2008.
have you found any solutions?

FLJ
Post #1433628
Posted Thursday, March 21, 2013 7:26 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, May 7, 2014 1:53 PM
Points: 72, Visits: 289
Unfortunately I have not made any progress on this issue. As you can see, it has been a quiet thread as well. I will update this thread with any further information I gather.
Post #1433776
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse