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.
From Start > All Programs > Internet Explorer, Right Click and choose Run as administrator.
Enter the reporting services URL: http://localhost/Reports [you may have different URL].
Running as administrator allow us to access the site settings. Click on it.
The General site settings page will be displayed.
Click on Security and choose New Role Assignment.
Add the username or group that you want to grant permission to and select the appropriate role.
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.
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.