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.
One last check is to make sure that Firewall is not causing the issue.