Home Forums SQL Server 2005 Administering Error: Server local connection provider has stopped listening on [ \\.\pipe\SQLLocal\MSSQLSERVER ] RE: Error: Server local connection provider has stopped listening on [ \\.\pipe\SQLLocal\MSSQLSERVER ]

  • Spicoli (10/9/2008)


    I am occasionally seeing the following error on two of our SQL 2005 64bit servers. (build 9.0.3239)

    [font="Courier New"]"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."[/font]

    The "automatic re-establish" works within a minute and the servers seem to continue to function correctly, but I'm still interested in knowing what's causing the error.

    There isn't anything in the server Event logs and there is minimal load on the server at the time.

    Anyone seen anything like this before? I've had a look on the web but can't see much about it.

    Cheers

    Please enable named piped protcol in sql server.

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj