SharePoint 2007 Troubleshooting: Event ID 5586

Issue: Event ID: 5586 Generated in the SharePoint server.

Error: Event ID 5586 generated in SharePoint Server application event logs.

Event Type:      Error
Event Source:  Windows SharePoint Services 3
Event Category:            Database
Event ID:          5586
Date:                09/10/2013
Time:               10:24:22
User:                N/A
Computer:        ++++++++++++
Description:
Unknown SQL Exception 1035 occurred. Additional error information from SQL Server is included below.

Background: As a part of daily health check on the server, we have noticed a lot many occurrences of the event ID 5586 on multiple servers.

This is something occurs on regular intervals but not specific to one server.

By looking at some of the references on the internet we happened to find the TechNet Article which talks about the possible resolution of this error.

Resolution: This error occurs in both the versions of SharePoint i.e. 2007 and 2010. However, in this case it was reported for SharePoint 2007.

Remedies for SharePoint 2007: http://technet.microsoft.com/en-us/library/cc561042(v=office.12).aspx

Remedies for SharePoint Server 2007: http://technet.microsoft.com/en-us/library/ee513056(v=office.14).aspx

Great thanks to MS to keep the record of the most relevant event IDs and sharing the possible remedies.

If you feel any difficulty in following any of resolution listed in the articles, let us know in the comments below.

Products Applies to: SharePoint 2007, SharePoint Server 2010, Windows Sever 2003, Windows Server 2008, SQL Server 2005 and SQL Server 2008.