Reporting Services Permissions for SQL Server R2 SSRS

Question

I get the error below when trying to access SSRS on SQL Server 2008 R2

I'm not sure how many others started using SQL Server 2008 SSRS, but I got a problem getting the error below when I try to access the report server URL

The user does not have the required permissions. Ensure that sufficient Windows User Account Control (UAC) permissions are granted; restrictions have been addressed

I can access the url if I run IE as admin

Answer 1

It helped me. http://thecodeattic.wordpress.com/category/ssrs/ . Go to step 35 to see the error you are getting. To paraphrase:

After you can log into your server / reports as an administrator, click "Home" in the upper right corner, then "Folder Settings" and "Assign New Role". Enter your username and check the box for each role that you want to provide. Finally, click OK. Now you can browse folders without opening an elevated browser.

Remember to set security at the site level ** AND ** at the folder level. Hope this helps.

Rick

Answer 2

You need to set permissions in SSRS in two places to give you initial access. The setup program only provides access to Builtin \ Administrators, to access it, you need to right-click on the browser link and select "Run as administrator".

• Launch Internet Explorer as Administrator
• Open the URL of the report manager, this time you must log in
• Go to Site Settings in the upper right corner
• Click Security, then Assign New Role
• Enter the domain name \ username and select "System Administrator", click "OK"
• Add other users as needed
• Click "Home", Folder Settings , then "Assign New Role"
• Enter the domain name \ username and select Content Manager, click ok
• Add other users as needed
• Reopen Internet Explorer (not an administrator) and double-check the URL.

Answer 3

in my case, this error is resolved by adding a permission level to the root folder.

i previously granted permission only to 2nd place. one in the site’s settings and one in a new folder that has special permission.

, but also required user permission to view the root folder. Note. Root Folder Option

another time I had a similar problem and adding users to the next group of windows SQLServerReportServerUser $ server_name $ MSRS10_50.MSSQLSERVER and starting IE as administrator or disabling UAC resolved my problem.

Answer 4

I think I tried everything that was mentioned here, and it still didn't work. It turns out that he did not recognize the login of my domain on the server as being in the Administrators group, because it was hidden through my membership in another group (developers), which is a member of the Administrators group.

I added my individual domain \ login to the Administrators group explicitly, logged out, and then turned on again in this window, and IE allowed me to the Report Manager home page, without requiring me to start IE as an administrator.

Answer 5

If this still does not work, try unchecking "Enable Protected Mode" in IE.
Add your site to the local intranet in Tools → Internet option → Security tab. Then uncheck the "Enable protected mode". Restart IE

Answer 6

In my case, after starting IE as an administrator, I had to add the report manager URL to the local Internet zones in Internet Explorer, and not to trusted sites.

Answer 7

This problem occurs because of UAC and only when IE starts on the same computer is the SSRS service enabled.

To fix this, you must add the AD group of read-only users to the actual directories of the SSRS websites and disable the security system. UAC is stupid, as if you are the administrator on the box. It will not allow you to access the data if you also do not have access to the data using other means, such as an AD group that is not related to the administrator, which applies to files.