Server local connection provider has stopped listening on [ \\.\pipe\SQLLocal\MSSQLSERVER ]

I come across following errors on Dev SQL Server 2005 over the weekend. The issue occurred first time in last 4 months, is not repeated in last few days! I am not taking any action as this is not occurring any more but if you see the Error Log often, you need to find the app causing this problem and fix it.

Server local connection provider has stopped listening on [ \\.\pipe\SQLLocal\MSSQLSERVER ] due to a failure.
Error: 0xe8, state: 4. The server will automatically attempt to re-establish listening.

The error code 0xe8 indicates the pipe is being closed.

Check the time it took to connect back from SQL Error Logs
20140311_01_jpg

Make sure, Named pipes protocol is enabled using SQL Server Configuration Manager
SQLServerConfigurationManager

Make sure to select in SQL Surface Area configuration tool
SQL-SurfaceareaConfigurationTool

One last check is to make sure that Firewall is not causing the issue.

References:
http://dotnetnotforcompletedummies.blogspot.in/2008/12/its-firewall.html
http://blogs.msdn.com/b/sql_protocols/archive/2005/12/22/506607.aspx
http://www.sqlservercentral.com/Forums/Topic634900-146-1.aspx
http://www.sqlservercentral.com/Forums/Topic583633-146-2.aspx

Advertisements
This entry was posted in SQL, SQL Error, Useful Link and tagged , , , , , , , , , . Bookmark the permalink.

One Response to Server local connection provider has stopped listening on [ \\.\pipe\SQLLocal\MSSQLSERVER ]

  1. Matt says:

    I was seeing the error through my Administrative events on my SCCM2012r2 server.
    Followed the advice on the blog linked below and the error messages have gone.
    I did check the named pipes was enabled but that wasn’t it.
    Increasing the ram available to the IIS server was the answer.
    I’m posting it here simply to help someone else hunting with the same error.
    https://www.404techsupport.com/2016/03/iis-wsus-private-memory/

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s