Event Id 5586

Update: Before going to all the trouble below, it is possible that a windows update might have wiped out your cliconfg settings on the sharepoint front end. To verify this, go to Start/Run and type in cliconfg. In the box on the right you should have TCP/IP followed by Named Pipes and the checkbox to enable shared memory should be checked. If it doesn't look like that, fix it and reboot. If this doesn't work, proceed to the next steps.

 

This error message usually occurs with others such as Event Id 3355, Event Id 7888 and Event Id 27745. There are probably many ways to fix it, but this is what worked for me.

 

First try the easy way out:

1. Reboot your SQL Server

2. Reboot the remaining servers in the SharePoint farm

3. Run these scripts exactly as instructed, even if you did not change the passwords, just run it to remind SharePoint what the passwords were in teh first place. http://support.microsoft.com/kb/934838/en-us

 

That might do the trick. If not:

1. Install WSS 3.0 SP1 and MOSS 2007 SP1

2. Repeat steps 1-4 above.

 

Details of the error:

Event Type: Error
Event Source: Windows SharePoint Services 3
Event Category: Database
Event ID: 5586
Date:  1/9/2008
Time:  10:57:00 AM
User:  N/A
Computer: SPWEB01
Description:
Unknown SQL Exception 53 occured. Additional error information from SQL Server is included below.

An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

 

Good luck.

-ann wallinger