Report Builder Minimum Rights
-
I recieve the following error when I attempt to creat a report using report builder. When I add the user that acceses this data source to the administrators group on the server the build works.
Is there a group I can use that will allow me to build reports without grant the user admin rights?
Or is there another way I should approach.
For more information about this error navigate to the report server on the local server machine, or enable remote errors
----------------------------
Logon failed.
----------------------------
Cannot impersonate user for data source 'dataSource1'.
----------------------------
An error has occurred during report processing.
-
You need to grant permissions on the database. In your datasource, you can set the connection properties to connect using either the user's credentials (who have appropriate permissions on the database) or set it such that "credentials stored securely on report server" and enter SQL login and password (for a sql login that has appropriate permissions on the database).
If you're using a shared datasource, you can only change the datasource settings by connecting to the Report Server in Management Studio, find your datasource and edit properties there.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply