There are two issues that you will find out when you finish the installation of SQL Server 2008 R2 as well as 2012:
When you try to access Reporting Services using your IE browser, it will constantly prompt you to enter username and password.
After the successful entry of login details in IE, you will get the following error message:
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.
To resolve the first issues I guess most people can find the right place, but please double check the following steps.
1. From Start > All Programs > Internet Explorer, Right Click and choose Run as administrator
2, Enter the Reporting Services URL: http://localhost/Reports/
3. Running as administrator will allow you to have access to Site Settings. Click on it:
4. Click on Security from the left side menu and choose New Role Assignment:
5. Add the username or Group that you want to grant permission to and select the appropriate role:
To resolve the second issue, please check the following setup.
1. 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:
Somebody even comment as below for the second issue, but actually you definitely needn’t add the user to server local admin group and just add the user in upper setting, it will work.
We are trying to set SSRS 2008 report access as documented at the following link
[http://msdn.microsoft.com/en-us/library/aa337494.aspx] and getting the error below:
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.
We are using Microsoft SQL Server 2008 (SP2) – 10.0.4000.0 (X64) Sep 16 2010 19:43:16 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2) and SSRS 2008 SP2 as well.
IE8 – tried it with Protected Mode enabled/disabled no luck.
Windows User Account Control is turned OFF on our SSRS reporting server box.
We tried pretty much all suggestions from the link below and nothing other than local admin group (which is unacceptable) can access Report Manager URL to view reports and their history as per “View Reports” description of the Browser SSRS default role.