Report Manager - Error 401 unauthorized when generating a report, the account does not have Content Manager and System User roles

Last Modified

Mon Nov 30 16:51 GMT 2020

Description

  • The following error message appears when trying to generate a report within Report Manager:
    • Error: The request failed with HTTP status 401: Unauthorized.
  • The account does not have Content Manager and System User roles

Environment

  • N-able N-central
  • Report Manager

Solution

  • To resolve this, please do the following:
  1. Add the Content Manager role:
    1. Right-click 'Internet Explorer'
    2. Select 'Run as administrator'
    3. Browse to the 'SQL Server Reporting Services' web interface - i.e. http://localhost/Reports
    4. Depending on the OS, select either 'Folder Settings' or the 'Properties' tab
      • NOTE: For SQL Server 2008 R2, it is 'Folder Settings', for SQL Server 2008 select the 'Properties' tab
    5. Editthe appropriate account that you would like to grant Report Manager access to
      • NOTE: To access this you would need to run Internet Explorer as an administrator to access this setting, as described in steps 1 and 2 above
      • NOTE: If you cannot locate the account then please create a new role by doing the following:
        1. Select 'New Role Assignment'
        2. Type the Windows account username in the field provided
    6. Enable the 'Content Manager' role for the account
    7. Select 'OK' or 'Apply' to assign the role this account
  2. Add the System User role:
    1. Right-click 'Internet Explorer'
    2. Select 'Run as administrator'
    3. Browse to the 'SQL Server Reporting Services' web interface - i.e. http://localhost/Reports
    4. Select 'Site Settings', which can be found in the upper right corner
    5. Select 'Security'
    6. Editthe appropriate account that you would like to grant Report Manager access to
      • NOTE: To access this you would need to run Internet Explorer as an administrator to access this setting, as described in steps 1 and 2 above
      • NOTE: If you cannot locate the account then please create a new role by doing the following:
        1. Select 'New Role Assignment'
        2. Type the Windows account username in the field provided
    7. Enable the 'System User' role for the account
    8. Select 'OK' or 'Apply' to assign the role this account