• Register
Welcome to Kodlogs, programming questions and answer website.
0 votes
16 views

Issue:


Environment:

Product Name    SQL Server
Event ID    rsAccessedDenied
Event Source    Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings
Component    Reporting Services
Application     Web Portal
Project Env     vb.net application


Using above environment when i have published my website on local enviornment, When i open report and try to run report i am getting following error:


"The permissions granted to user 'IIS APPPOOL\DefaultAppPool' are insufficient for performing this operation. (rsAccessDenied)"

What could be the issue for this message, any help , i am beginner ?

by (330 points)  
edited by

1 Answer

0 votes

Resolution:

The main reason for this issue is the user might not have enough permission and needs to have sufficient privelage to run report.


Step 1

“Run as Administrator” to start the IE
Open your local report where it is hosted ie https://ServerName/Reports
GO to Security>New Role Assignment
Add DOMAIN/USERNAME or DOMAIN/USERGROUP

Step 2

Access Folder Settings
Click Security->New Role Assignment
Add DOMAIN/USERNAME or DOMAIN/USERGROUP
Go to the Report URLie https://ServerName/Reports


Further Reading:
https://docs.microsoft.com/en-us/sql/reporting-services/troubleshooting/rsaccesseddenied-reporting-services-error?view=sql-server-2017
 

by (1.4k points)  
...