Hello, I have put my web project (which uses reporting services) into the web server for testing. All works fine on th elocal machine but on the server I get this error when trying to access the reports: The permissions granted to user 'NT AUTHORITYNETWORK SERVICE' are insufficient for performing this operation. (rsAccessDenied) What do I do to solve this please? thanks
I have now done this: go to the property tab and create a new group with name BUILTINUsers And in the role assignment tick browser role Now the error is : An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'dsDB'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors Any thoughts please? thanks
Not my specialty, but "browser role" doesn't sound like it actually gives access to the database. The account under which the web project will be executing (seems to be currently "NT AUTHORITYNETWORK SERVICE") needs to be mapped to a login and have db access, and the login needs to be member of the appropriate database role(s).
This is impersonation issue, you should go to the reports manager (http://servername/reports) and go to the property tab and create a new group with name BUILTINUsers And in the role assignment tick browser role
