October 29, 2020
ssrs crystal report

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.

Rashedul Alam

I am a software engineer/architect, technology enthusiast, technology coach, blogger, travel photographer. I like to share my knowledge and technical stuff with others.

View all posts by Rashedul Alam →

One thought on “Domain\User Does Not Have Required Permissions

Leave a Reply

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