Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
What permissions are rquired for a user to see the report manager?

Proposed What permissions are rquired for a user to see the report manager?

  • Wednesday, March 06, 2013 11:59 AM
     
     
    Sign In to Vote
    0

    Hi,

    I have just done a clean install of SSRS SQL 2012.  When I go to the reports page

    User '<username>' does not have
    required permissions. Verify that sufficient permissions have been granted and
    Windows User Account Control (UAC) restrictions have been addressed.

    This user is sysadmin on the SQL server and I have clicked Site Settings > Security and added him in as SA, System Administrator and System User.

    What am I missing?

    Thanks,

    Zoe

     

All Replies

  • Wednesday, March 06, 2013 12:27 PM
     
     Proposed
    Sign In to Vote
    1

    Hi Zoe,

    • Go to Home in Report Manager
    • Click on Folder Setting
    • Go to Security
    • Add username here and assign the role

    Please let me know if issue will not  be resolved

    Please Mark as Answer if my post solved your problem or Vote As Helpful if this helps. Blogs: www.sqlserver2005forum.blogspot.com

     
  • Thursday, March 07, 2013 9:11 AM
     
     
    Sign In to Vote
    0

    Thanks Rahul, but I have already done that.

    I have discovered that if I add the user to the administrators group on the server, they can access the reports.

    I have created another server group called SSRS users.

    Obviously Administrator access is too much permissions. What do I need to grant to the SSRS users group to allow them to gain access?

    Thanks,

    Zoe

     
  • Tuesday, March 12, 2013 7:15 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi Zoe,

    Based on the current information, the issue may occur due to the IE security settings or the UAC feature on the client computers. Here, I suggest that you try the following steps:

    1. In the report manager, assign the Browser Item-level permission to the new created user group.
    2. On each client computer, add the http://<Report Server Name> URL into the trusted site list of the IE.
    3. Launch the IE by clicking “Run as administrator” when browsing the report manager on each client box.

    Reference:
    Configure a Report Server for Local Administration on Windows Vista and Windows Server 2008

    Regards,

    Mike Yin
    TechNet Community Support

     
  • Monday, March 18, 2013 8:40 PM
     
     
    Sign In to Vote
    0

    Thanks Mike, but im afraid that didn't work. The only thing that seems to work is when I add them to the administrators group on the server (which obviously isn't an acceptable solution).

    I don't understand it

     
  • Wednesday, March 20, 2013 2:12 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi Zoe,

    Thanks for your posting.

    I am afraid that you didn't set the Item-level permission properly as I suggested in my previous post. Please ensure the following steps are finished: 

      • In Report Manager, on the Home page, click Folder Settings.

      • In the Folder Settings page, click Security.

      • Click New Role Assignment.

      • Type your Windows user account in this format: <domain>\<user>.

      • Select Content Manager.

      • Click OK.

  • Regards,

    • Mike Yin
    TechNet Community Support

 
  • Wednesday, March 20, 2013 2:14 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi Zoe,

    Thanks for your posting.

    I am afraid that you didn't set the Item-level permission properly as I suggested in my previous post. Please ensure the following steps are finished:

    1. In Report Manager, on the Home page, click Folder Settings.
    2. In the Folder Settings page, click Security.
    3. Click New Role Assignment.
    4. Type your Windows user account in this format: <domain>\<user>.
    5. Select Content Manager.
    6. Click OK.

    Regards,

    Mike Yin
    TechNet Community Support