I've been running SSRS with an administrator account during development. Now I am trying to deploy it for users. I have a Domain group, SQL Users, that I've added to Report Manager. I've given the group the following roles (same as
the administrator account I use to run reports): Browser, Content Manager, My Reports, Publisher, Report Builder.
When a SQL User tries to run a report they get:
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for data set 'Division'. (rsErrorExecutingCommand)
For more information...
What permissions am I missing that is preventing the user from accessing data from the datacube?
View Complete Post