Recently we faced with the following issue: on one of WFE in production farm the following error from OWSTIMER process flooded the event log:
Unknown SQL Exception 297 occurred. Additional error information from SQL Server is included below. The user does not have permission to perform this action.
This error occurred for all Sharepoint system databases:
- managed metadata
- user profile
- usage and health
- user profile sync
- web analytics reporting
In order to avoid this error we need to grant VIEW SERVER STATE permissions to account which is used for OWSTIMER process. In Sql management studio run the following command:
GRANT VIEW SERVER STATE TO [domain\user]
After that error should disappear.