question

BrandonHo-7950 avatar image
0 Votes"
BrandonHo-7950 asked Joyzhao-MSFT commented

SSRS 2019 The permissions granted to user 'domain\xyzuser' are insufficient for performing this operation. (rsAccessDenied)

Hi,
I have a summary report in the Accounting folder which allow user to drill down to the detail report. When user click on a cell, I have the Action to Go to Report within the text properties. When user click the cell from the summary report, it will pass two parameters to the detail report. User will get a message "The permissions granted to user 'domain\user' are insufficient for performing this operation. (rsAccessDenied)" error. User is defined as a member of the AcctReport Group with Browse access role in the Accounting folder. User can run the detail report directly from the Accounting folder by providing the two parameters with no issue. Only the drill down to another report will get the error. I tried to include the Content Manager option of the AcctReport role does not make any difference. I asked the user to run the Browser as Administrator option would not make any difference. Any idea why it is causing the error?

Thanks in advance.

Brandon.

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT commented

Hi @BrandonHo-7950

Only the drill down to another report will get the error.

Please make sure that the user has the browse permission of the another report and the data source access permission of the detailed report. Does the another report exist in the same folder? Do you use the same data source?
Can the user open the another report directly instead of using the "Go to report" Action?
Best Regards,
Joy


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Joy,

The detail and summary report is using the same share data source. They are in the same folder. User can open the detail report directly instead of using the "Go to report" from the summary report action. When user open the detail report, it requires the user to fill in the parameters instead of passing from the summary report.

Thanks,
Brandon.

0 Votes 0 ·

Please reproduce the error and check the error log in the following path: C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles

0 Votes 0 ·

library!ReportServer_0-49!7ac!05/17/2021-19:33:43:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: , Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'domain\xyzuser' are insufficient for performing this operation.;


I
It turns out I deleted the detail report then re-upload to SSRS to make it works.

Thanks,
Brandon.

0 Votes 0 ·
Show more comments
BrandonHo-7950 avatar image
1 Vote"
BrandonHo-7950 answered

User is no longer getting access denied after I delete both reports then re-upload to SSRS.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.