“User Does Not Have Permission to Perform this Action”

One of those really annoying messages which gives little or no hint as to what user is having the issue.  I saw this when using ULS Viewer to check for other issues I was having with a SharePoint farm.

IOWSTIMER.EXE (0x09A8) 0x0C20 SharePoint Foundation Database 5586 Critical
Unknown SQL Exception 297 occurred. Additional error information from SQL Server
is included below. The user does not have permission to perform this
action.

What the heck was this about?  Why was I only seeing it on one of the Web Front End Servers not all of them? how to solve it?

Well I can’t necessarily answer the second point, but it was due to the Service Account which ran the Timer Service not having sufficient permission on the SQL Server that was hosting the website Content Database.  I found the  answer in this rather obscure Technet Forum thread .  Basically you need to run the following bit of SQL code:

GRANT VIEW SERVER STATE TO [your timer account]

You will find this does in fact solve the issue. Bizarre…

Cheers

Dave Mc

Advertisements

About davemcmahon81
Software Developer & Architect, User Group Leader, Speaker, Writer, Blogger, Occasional Guitarist, Man-made Global Warming Sceptic, Climate Change Believer, General Optimist but most of all proud Husband and Dad ...

3 Responses to “User Does Not Have Permission to Perform this Action”

  1. Nelson says:

    Thank you. This fixed our issue after a SQL server rebuild.

  2. mlucasg says:

    It worked!
    Thanks!

  3. ee61re says:

    Same issue here after a move to a new SQL cluster – your fixed worked for us too – many thanks!

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

%d bloggers like this: