Advertisements
Home > SSRS > SSRS and UAC (User Access Control)

SSRS and UAC (User Access Control)


Error Message : “User does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed”

One of the frequently asked question in many forums is “I am an admin on the machine (Windows Vista or Windows 7 or Windows 2k8) where SSRS is installed but I am not able to access the reports”.

Recently I faced a similar issue. I am an admin on the machine which has Windows 2008 R2 installed. On top of it, I installed SSRS 2008 R2 and then configured the RS with proper values.

Then when I tried to access the report manager by navigating to the URL, I got an error message like

User ‘Domain\User’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.
 

I once again checked my configuration but everything looked fine. Since the error message gave some hint on UAC, I ran the browser as admin and navigated to the report manager. Now it did not throw any error message. I was able to see the home page and all other menu including the Site Settings.

I added myself as System Admin in the Site Setting

Closed the browser and opened it again in normal mode. Still  it was throwing same error.

Opened the browser again in Admin mode. Navigated to the home folder and added myself and assigned to all the roles.

After this when I ran the browser in normal mode, I was able to access all report manager and all the folders.

The issue is that by default UAC allows the users (even the administrators) to do the tasks with the privilege of normal user, i.e, say when you open the browser or an application, it is opened with the normal user’s privilege and not that of administrator’s privilege.

What I understood is that when I opened the browser in normal mode, UAC passed standard user’s privilege to SSRS and hence SSRS was not able to identify that I am an admin. To get the admin access either I have to run the browser in admin mode or add myself explicitly to SSRS System Admin roles.

So you have two options to tackle this issue

1) Fix it at your SSRS end as outlined above  (or)

2) Manage your UAC appropriately.

For managing UAC account follow the following steps

  1. Go to Control Panel
  2. Select User Accounts
  3. Change User Account Control Settings

Change notify option to never notify and press OK

I hope this would be helpful 🙂

Advertisements
Categories: SSRS
  1. Madhav
    November 14, 2013 at 10:48 am

    I found the solution 🙂

  2. Andrew
    September 15, 2014 at 3:57 pm

    Thanks for this, answers an easy question simply.

  1. No trackbacks yet.

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: