The permissions granted to user ‘NT AUTHORITY\NETWORK SERVICE’ are insufficient for performing this operation. (rsAccessDenied)
I had come across this error a few years ago but had forgotten what the fix was for this.
We faced the same error while configuring the reports on one of our production servers.
We were trying to access the reports from a ASP.net application. The reports worked well when tried to access directly from the browser i.e. using http://localhost/reports . But when the same was accessed by the report viewer control in a web site it used to give an error saying :
“The permissions granted to user ‘NT AUTHORITY\NETWORK SERVICE’ are insufficient for performing this operation. (rsAccessDenied) “
The fix to this problem is very simple:
- login to the reports manager, by going to http://localhost/reports.
- Go to the properties tab.
- Click on “New Role Assignment”
- Add the user / group which is going to be used to access the reports from the asp.net application. In my case it was “NT AUTHORITY\NETWORK SERVICE”.
- Set appropriate permissions.. Just to access the reports “Browser ” should be sufficient.copyright : http://sqldude.wordpress.com/2008/12/24/the-permissions-granted-to-user-nt-authoritynetwork-service-are-insufficient-for-performing-this-operation-rsaccessdenied/
Error “The permissions granted to user ‘\IUSR_’ are insufficient in Reporting Server
If you get this error “The permissions granted to user ‘\IUSR_’ are insufficient for performing this operation.” when you work with Reporting Server, it is because the reporting server’s virtual directories under IIS is running in ‘Annonymous Mode’. To fix this open IIS, right click on the virtual directory that your report server uses, click on the tab ‘Directory Settings’ and click edit under ‘Authentication and Access Control’ and untick the ‘Enable Anonymous Access’