I've been developing a BI solution with SQL/SSRS/SSAS 2005. I've done all the development with an account that has full admin permissions on the server. Now I am trying to give users access to the data without admin permissions. When a
user runs an SSRS report that queries an SSAS cube I get the following error:
An error has occurred during report processing. (rsProcessingAborted) Query execution failed for data set 'Division'. (rsErrorExecutingCommand).
Since I don't get this message when I run the report I'm thinking it's a permission thing. I set up a domain user group, 'SQL Users', and gave them access to the SQL Server Reports database
and the Report Manager but don't know if I have to grant permissions on the SSAS database. SSAS doesn't use the same security settings that SQL uses. I added SQL Users as a role in my database but that didn't help.
I'm not sure what else to try...
View Complete Post