During the process of report deployment, you want to publish your finished reports and thus you go to SSRS Configuration Manager, and choose Web Service URL on the left pane, and then click on the URL link on the right side. A new web browser page would popup and your report hub main page will appear. Everything worked just as expect. However, If you copy the URL link of your report main page and close the web page, and open a new web page, paste the copied URL link. Guess what would happen? You would suffer SSRS Report Service ERROR like this:
"The permissions granted to user 'your domain\your user name' are insufficient for performing this operation. (rsAccessDenied)".
Why this happen? The first time worked fine because the windows account used by SSRS Configuration Manager was used to access the report main page. However, if you close the web page, and opened a new one to access the same report main page, the underline windows account, which is your own account, will be used instead, and this user doesn't have any access right to the report. so the above error will surely happen.
How to resolve this common error?
Open SSRS Configuration Manager, and choose Report Manager URL on the left pane, click on the URL link on the right side and a new web page would popup to show your Report Manager URL.
Click on the
Folder Setting on above buttons.
Click on the
New Role Assignment, and enter yourdoman/yourname showed on above error, and check all available roles.
Now your account has been assigned enough roles to run the reports.
No comments:
Post a Comment