SSRS 2019 permissions granted to user domain\user are insufficient

Question

Reporting Services Error

• The permissions granted to user 'DOMAIN\user' are insufficient for performing this operation. (rsAccessDenied) Get Online Help

I had this issue in the past with Windows 10 and the solution was to run it in IE 11 under administrator as per this article:

https://learn.microsoft.com/en-us/answers/questions/453441/the-permissions-granted-to-user-domainuser-are-ins

As IE 11 is not available anymore I am struggling to get this working. I'm using MS Edge with Single Sign On and my computer is signed in using my Microsoft work email.

I tried re-installing my instance of SSRS, re-setting up the WebService URLs, creating a new ReportServer database in SQL Server and configuring the Report Server database credentials in the Report Server Configuration Manager. This didn't work.

I also tried going into the users and policyuserrole tables in the ReportServer database and manually added my account and SSRS roles to it. This didn't work.

Can anyone help me get this working? Is there something specific to my environment that could be causing this?

Answer 1

Hi @Yosef Shellim

Is your account an administrator account? On a newly installed report server, only users who are members of the local Administrators group have permissions to report server content and operations.

You can refer to this link: https://learn.microsoft.com/en-us/sql/reporting-services/security/grant-user-access-to-a-report-server?view=sql-server-ver16.

Best regards,

Aniya