Event 2159 / 5586
Event 5586 (SharePoint Foundation) of severity 'Error' occurred 540 more time(s) and was suppressed in the event log.
Reasons for this Event:
1.Open the SQL Server Configuration Manager (assuming you are using SQL 2008 or higher)
2.Browse down to SQL Server Network Configuration – Protocols for <namedserverinstance>
3.Right-click “Named Pipes” in the right pane and choose Enable
4.You may need to restart the server for changes to take effect
Granting the farm database access account “VIEW SERVER STATE” under the SQL Server properties will also resolve this issue.
GRANT VIEW SERVER STATE TO [domain\timer_service_user]