theme-sticky-logo-alt

Unknown SQL Exception 297 occurred. Additional error information from SQL Server is included below.

7 Comments

I recently came across Unknown SQL Exception 297 in the Event Viewer in two of my SharePoint Deployments.   One with SQL 2012 and one with SQL 2008 R2.

Here is the full error message.

Unknown SQL Exception 297 occurred. Additional error information from SQL Server is included below.The user does not have permission to perform this action.


Event ID: 5586
Luckily, this error is pretty easy to repair. You have to grant the “View server state” permission to the farm account on the database.  Here is How you do it on both servers 

SQL Server 2008R2

1. Open SQL Management Studio and login to the instance where your SharePoint is installed.
2. Go in the Database Properties
3.  Go to Permissions and Select your Farm Account. 
4. Find the Permission “View Server state” and check the “grant” checbox
5. Click OK.  If you want to make sure that the permissions applied, just go on the tab called “Effective” and you should see the permission at the end of the list.
SQL Server 2012

1. Open SQL Management Studio and login to the instance where your SharePoint is installed.
2.  Open the Security Tab, Select your Farm account and click Properties.
3. Go in the Securables Section, Scrolldown and you will see the “VIEW Server State” , check “grant”

4. Click OK.

Uknown SQL Exception297 should stop appearing in your Event Viewer. 

If this was helpful, say thanks in the comments :). 

Previous Post
Create and Provision a Search Service Application With Powershell
Next Post
How to Check if SharePoint services are started and with what account they are running

7 Comments

  • June 16, 2012 at 3:01 am
    Anonymous

    Thanks 🙂

    Reply
  • May 30, 2013 at 7:01 pm
    san

    thanks

    Reply
  • August 7, 2013 at 9:44 am
    Anonymous

    thanks

    Reply
  • March 26, 2014 at 12:24 pm
    ngio

    BIG thanks!

    Reply
  • April 1, 2014 at 7:35 am
    Marko

    thanks

    Reply
  • November 11, 2014 at 6:21 pm
    Vince

    Great post, fixed us right up. Thank you.

    Reply

Leave a Reply

15 49.0138 8.38624 1 0 4000 1 https://vladtalkstech.com 300 1