Error: The permissions granted to user ‘DOMAIN\user01’ are insufficient for performing this operation. (rsAccessDenied)

User permissions need to be setup both at the SQL Server and SSRS.

Account can be both SQL Server account or NT account.

SQL Server

  • Account has access to database. (Database -> Security)

SSRS

  • Reports pointing to correct Data Sources file. (Report -> Manage -> Data sources)
  • Data source file configured to use account. (Data Sources folder)
  • Report folder and Data Sets folder have account added to correct Roles. (Folder -> Manage > Security)
Last modified: February 24, 2020

Author

Comments

Write a Reply or Comment