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.
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.
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.
Step4 The General site settings page will be displayed.
Step5 Click on Security and choose New Role Assignment.
Step6 Add the username or group that you want to grant permission to and select the appropriate role.
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.
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.
Thank you so much for this article..It helps me a lot..Now its clear..