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, I have noticed allot 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 some of the reference on the internet I happened to find the TechNet Article which talk about the possible resolution of this error.

Resolution:

This error occurs in both the versions of the SharePoint i.e. 2007 and 2010; however in my case it was reported for the SharePoint 2007.

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

Remedies for SharePoint Server 2010: http://technet.microsoft.com/en-us/library/ee513056%28v=office.14%29.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, do let me know. I would be more happy to help you put with.

Products Applies to:

1)      SharePoint 2007

2)      SharePoint Server 2010

3)      Windows Sever 2003

4)      Windows Server 2008

5)      SQL Server 2005 and SQL Server 2008.