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

eventid-5586-sql-exception-297

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

db-server-properties-permissions

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

view-server-state-effective-permission

Advertisements

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s