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:

https://technet.microsoft.com/en-us/library/cc561042(v=office.12).aspx

 

 

Possible Fix:

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.

 

use [master]

GO

GRANT VIEW SERVER STATE TO [domain\timer_service_user]

GO