Sandeep, When you are adding the user through New Role assignment, what role you are giving the user? - Try giving it all the rights (Browser, Content Manager, My Reports .. etc) and check if it is working. In the Dataset of the report, are you authenticating the user? Regards - Manoj

Hi Manoj, Thanks for your reply. I gave all rights to user, but still no luck, but when i add to windows administrator group everything is fine. Pls advise where all i need to give permission to a domain user-- Kind Regards Sandeep

What I dont able to understand with the error you posted earlier: User is getting Query execution failed for dataset ''. (rsErrorExecutingCommand) . Can you post the exact message? Regards Manoj

Hi Manoj, Below is the error i get when i open any report on report by login a test user. An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset 'UserGeoDimVehicleDealerOrigin'. (rsErrorExecutingCommand) For more information about this error navigate to the report server on the local server machine, or enable remote errors

Hi All, I want to give permissions to a domain user to access reports. I am facing problem in give permissions ..i had added user to report manager --> site settings -->Security --> New role assginment and added to System user. But i get exception An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset ''. (rsErrorExecutingCommand) ...but when i add user to windows administrator group its working all fine.. please advise where i can give permissions. -- Kind Regards Sandeep

Hi Sandeep, Thanks for your question and Manoj’s reply. According to the description through the thread, based on my research and experiences, the issue seems caused by the domain user has no permissions to execute the T-SQL query of the dataset 'UserGeoDimVehicleDealerOrigin'. Does your report’s Data source use Windows Authentication? If in this case, the report will pass the domain user’s account and password as the credential to the report server, then using this credential to access the database. If the domain user has no permissions, it will be this error. In order to resolve this issue, please grant the execute permissions to the user. There is a similar thread of yours, please see: http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/6c4a5f1d-ef08-4047-9b3e-8dff58264a33. Hope it helps you, if your issue still exists, please feel free to let me know. Thanks, Sharp Wang Best Regards. Sharp Wang

Hi Sharp, Thanks for your reply. I checked we had developed sql cube reporting. So i need to give permission to user in Analysis Services also. So after i gave permission the issue is resolved. So to wrap up ..i need to give permissions to user in 1. Sharepoint site. 2. Report Manager --> add user as content manager. 3. In SQL under Security and 4. in analysis services if using cube. Please advise if i am correct and covered all levels for permissions. -- Kind Regards Sandeep

Hi Sandeep, Apology for I didn’t know you were developing analysis cube reporting, so that I haven’t given you the exact direction. I’m glad to hear that you got it working. Thank you for sharing your solutions & experience here. It will be very beneficial for other community members who have similar questions. Thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help.