SharePoint 2010: Unknown SQL Exception 297 Error

Have you seen the following Event ID 5586 error in the Application 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


Then here are the steps to resolve it:

  1. Log on to the SQL Server machine that is serving the SharePoint databases.
  2. Right click the top most level (i.e. server) and select Properties
  3. Click Permissions
  4. Select the SharePoint farm account on the right pane top section
  5. In the Permissions for the SharePoint account (right pane, lower section), scroll down to locate the View server state permission
  6. In the Grant column, click to grant View server state permission
  7. Click OK to close the Server Properties dialogue window


To confirm the effective permission

  • Re-open the database server properties
  • Launch the permissions for the farm account
  • Click the Effective tab to confirm that View server state has been granted



One thought on “SharePoint 2010: Unknown SQL Exception 297 Error

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s