Reporting Services permissions on SQL Server R2 SSRS

Question

I m getting the error below when I try and access SSRS on SQL Server 2008 R2  I m not sure how many others have started using SQL 2008 R2 SSRS  but I am having an issue with getting the error below when I try and access the reports server url     User does not have required permissions  Verify that sufficient permissions have been granted and Windows User Account Control  UAC    restrictions have been addressed   I can access the url if I run IE as an administrator

User · Answer

You need to set permissions within SSRS in two places to give yourself initial access  The set-up program only gives access to Builtin Administrators  to gain access in order to do this you need to right click you browser link and choose Run as administrator    Run internet explorer as Administrator Open the report Manager URL  this time you should get in Go to Site Settings in the top right Click Security then New Role Assignment Enter your domain username and select System Administrator  click ok Add other users as necessary Click home  Folder Settings  then New Role Assignment Enter your domain username and select Content Manager  click ok Add other users as necessary Re-open internet explorer  non-admin  and recheck the url

User · Answer

in my case this error resolved by adding permission level to root folder    i previously only granted permission in 2 place  one in site setting and one in a new folder that has custom permission     but the user permission to browse the root folder was also required  Note The  Folder setting  in root folder  another time i had similar problem and  adding users in the following windows group  SQLServerReportServerUser servername MSRS10 50 MSSQLSERVER and running IE as Administrator or turning off UAC resolved my problem

User · Answer

I think I tried everything mentioned here  and it still didn t work   Turns out it didn t recognize my domain login to the server as being in the Administrators group because it was implicit 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 off and then logged back on to the box  and IE admitted me to the Report Manager homepage without requiring me to run IE as administrator

User · Answer

This problem occurs because of UAC and only when you are running IE on the same computer SSRS is on   To fix it  you have to add an AD group of the users with read priviledges to the actual SSRS website directories and push the security down  UAC is dumb in how if you are an admin on the box  It won t let you access the data unless you also have access to the data through other means such as a non-administrator AD group that is applied to the files

User · Answer

In my case after running IE as an administrator  i had to add the url of the report manager to the Local Internet Zones in Internet Explorer  not Trusted Sites

User · Answer

If this still isn t working try unchecking  Enable Protected Mode  in IE  Add your site to Local Intranet in  Tools -  Internet Option -  Security Tab Then uncheck  Enable Protected Mode  Restart IE

User · Answer

First  Make sure that the current user is a member of Local Administrator Group on the server that running SSRS to can manage SSRS permissions      Note  By default  the local admins have full permission to manage SSRS    Now  try to do the following    Run Internet Explorer as Administrator  Browse the Report Manager URL  Provide the user that has a permission issue the required permission as mentioned at User does not have required permissions  Verify that sufficient permissions have been granted and Windows User Account Control  UAC  restrictions have been addressed      Note  if the issue still exists  so it s not a permission issue  you   need to adjust the Internet Explorer settings as mentioned at User   does not have required permissions  Verify that sufficient permissions   have been granted and Windows User Account Control  UAC  restrictions   have been addressed

User · Answer

This did the trick for me  http   thecodeattic wordpress com category ssrs     Go down to step 35 to see the error you are getting   Paraphrasing   Once you re able to log in to YourServer Reports as an administrator  click Home in the top-right corner  then Folder Settings and New Role Assignment   Enter your user name and check a box for each role you want to grant yourself   Finally  click OK   You should now be able to browse folders without launching your browser with elevated privileges   Don t forget to set the security at the site level   AND    at the folder level   I hope that helps    Rick

[sql-server-2008] Reporting Services permissions on SQL Server R2 SSRS

Examples related to sql-server-2008

Examples related to ssrs-2008

Examples related to sql-server-2008-r2