rsAccessedDenied - Reporting Services Error


Applies To: SQL Server 2016

The Reporting Services error rsAccessedDenied occurs when a user does not have permission to perform an action. For, example, they do not have a role assignment that allows them to open a report or they did not open their browser with the required permissions.

Applies to:  Reporting Services Native mode | SharePoint mode
  • If the error occurred while accessing the report server directly through a URL, the exception is mapped to an HTTP 401 error.

  • If the error occurred while using Report Manager or another tool, the error appears in an error page.

  • If the error occurred during a scheduled operation, subscription, or delivery, the error will appear in the report server log file only.

Product NameSQL Server
Event IDrsAccessedDenied
Event SourceMicrosoft.ReportingServices.Diagnostics.Utilities.ErrorStrings
ComponentReporting Services
Message TextThe permissions granted to user 'mydomain\myAccount' are insufficient for performing this operation. (rsAccessDenied) (ReportingServicesLibrary)

Permission to access report server content and operations are granted through role assignments. On a new installation, only local administrators have access to a report server. To grant access to other users, a local administrator must create a role assignment that specifies a domain user or group account, one or more roles that define the tasks the user can perform, and a scope (usually the Home folder or root node of the report server folder hierarchy). You can use Report Manager to create the role assignments. For more information, search for "Role Assignments" in SQL Server Books Online.

This error is also caused by local administration of the report server. For more information, see Configure a Native Mode Report Server for Local Administration (SSRS).

Role Assignments
Granting Permissions on a Native Mode Report Server
Roles and Permissions (Reporting Services)

Community Additions