Log entry for EventID 5586:
Unknown SQL Exception 297 occurred. Additional error information from SQL Server is included below.
The user does not have permission to perform this action.
Log entry for EventID 2159:
Event 5586 (SharePoint Foundation) of severity 'Error' occurred xx more time(s) and was suppressed in the event log
What’s going on? This is occurring because your SQL Server has not been configured to use named pipes.
- Open the SQL Server Configuration Manager (assuming you are using SQL 2008)
- Browse down to SQL Server Network Configuration – Protocols for <namedserverinstance>
- Right-click “Named Pipes” in the right pane and choose Enable
- You may need to restart the server for changes to take effect
> EDIT < Christopher Hatton adds (from the comments):
Granting the farm database access account â€œVIEW SERVER STATEâ€ under the SQL Server properties will also resolve this issue.