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:        ++++++++++++
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 on e 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.

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:  
Remedies for SharePoint Server 2007:  
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: SharePoint 2007, SharePoint Server 2010, Windows Sever 2003, Windows Server 2008, SQL Server 2005 and SQL Server 2008.