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.