locked
SSRS 2012: The permissions granted to user '' are insufficient for performing this operation. (rsAccessDenied) RRS feed

  • Question

  • Hello

    Can you please help me with this error that I'm getting with SSRS 2012.  I've searched the forums and I can only find solutions for SQL Server 2008 and not 2012.

    When I try to go to the url on our server http://server:port/ReportServer, I get the following error.

    "The permissions granted to user 'WW004\z0008x5e' are insufficient for performing this operation. (rsAccessDenied)". 

    Can you please help me troubleshoot this.  I have not been able to find a solution.

    Andy


    • Edited by AndyMcV Tuesday, August 12, 2014 6:36 PM
    Tuesday, August 12, 2014 6:32 PM

Answers

  • Hi AndyMcV,

    According to your description, when you try to go to the URL http://server:port/ReportServer, the error occurred: The permissions granted to user 'WW004\z0008x5e' are insufficient for performing this operation. In fact, reporting Services uses role-based security to grant user access to a report server, and there are two types of roles: Item-level roles and System-level roles. On a new installation, only local administrators have access to a report server. In order to grant access to visit the URL http://server:port/ReportServer to users, a local administrator must create a role assignment to define the tasks a user can perform. To workaround this issue, please refer to the following steps:

    1. Start Report Manager by going to URL http://server:port/ReportServer.
    2. Click Site Settings at the top right of the page.
    3. Click Security in the left pane.
    4. If a role assignment already exists for the user, click Edit.
    5. Otherwise, click New Role Assignment. In user, enter the user account.
    6. Select appropriate access, and then click Apply.

    Besides, if the user need to have access to reports, folders, models and shared data sources, we can assign Item-level roles on the root node (the Home folder) or on specific folders or items.

    For more information about Role Assignments, please refer to the following article:
    http://technet.microsoft.com/en-us/library/aa337471(v=SQL.105).aspx

    If you have any questions, please feel free to let me know.

    Thanks,
    Wendy Fu


    • Edited by Wendy Fu Thursday, August 14, 2014 6:26 AM
    • Proposed as answer by Wendy Fu Monday, August 25, 2014 1:09 AM
    • Marked as answer by Wendy Fu Monday, August 25, 2014 7:06 AM
    Thursday, August 14, 2014 6:25 AM