Domain\User Does Not Have Required Permissions

SQL Server Reporting Services(SSRS) is a powerful tools for report generations. Working with SSRS some times we found errors. This article discuss and provides solution for a common error SSRS UAC (User Access Control). The common SSRS warning is:

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.

User-Account-Control

In order to solve this problem lot of solutions are available on the internet. By following the bellow steps we can easily overcome this this error.

Step1
From Start > All Programs > Internet Explorer, Right Click and choose Run as administrator.

ssrs

Step2
Enter the reporting services URL: http://localhost/Reports [you may have different URL].

Step3
Running as administrator allow us to access the site settings. Click on it.

ssrs-administration

Step4
The General site settings page will be displayed.

ssrs

Step5
Click on Security and choose New Role Assignment.
ssrs new role assignment

Step6
Add the username or group that you want to grant permission to and select the appropriate role.
ssrs

Step7
Now go to Home page and click on Folder Settings. Add the username or Group that you want to grant permission to the main Home page.
ssrs-folder-setting

Step8
Close the current browser and open a new browser. Visit your Reporting Services URL. It will work without an AUC error.

That’s all about AUC error.

Comments

  1. By LAVANYA

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *