I gave a user FULL blown permissions to SSRS Reporting manager, and when they put in the URL and the logon/PW pop up appears, they put in the user name / PW, the following message appears:

An error has occurred during report processing. (rsProcessingAborted)
The execution failed for the shared data set 'Years'. (rsDataSetExecutionError)
Cannot create a connection to data source ' Data source for shared dataset'. (rsErrorOpeningConnection)
Cannot open database "ABC" requested by the login. The login failed. Login failed for user 'AD\ssmith'.

Do I have to do anything at the database end in SQL 2012.  I only gave permissions at the Reports Manager end.

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
SSRS has 2 databases (reportserver and reportservertempdb). Did you give permissions on those databases for the user?
Vitor MontalvãoMSSQL Senior EngineerCommented:
SSRS has 2 databases (reportserver and reportservertempdb). Did you give permissions on those databases for the user?
Are you able to run this report? Or is it just this one user?
Did you happen to check the data source connection for the report within the Report Manager? It may be that it's searching for a shared data source connection that's not available/recognized in Report Manager.

Any chance you need to set execute or read only permissions for the database object that the report is calling for this specific user?
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

zero000koolAuthor Commented:
I gave users read access the reporting DBs above.
They can now see the folders / reports, but they cannot run the reports.

What permissions need to be given to execute reports.

Vitor MontalvãoMSSQL Senior EngineerCommented:
You need to give them permissions on RSExecRole roles for the SSRS databases.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
zero000koolAuthor Commented:
I gave them RSExecRole on both reporting db's, and they advise when they run reports they get a blank output.

Is there any other permissions I need to give them?

Vitor MontalvãoMSSQL Senior EngineerCommented:
Blank output? The reports may not return records at all? Do they have permissions to the tables that are in the reports definition?
zero000koolAuthor Commented:
The blank reports are in Chrome, which has a problem with output , known issue:


Also RSexec Role, under no circumstances do you give users permissions to this role:
zero000koolAuthor Commented:
I've requested that this question be deleted for the following reason:

Most of the answers did not work and were wrong.
Vitor MontalvãoMSSQL Senior EngineerCommented:
Can't understand your commentarie to close this question. Your main question was about permissions and after you got the answer from my comment you came with another question about blank report. You should opened another question but I tried to help you anyway.
I need to learn to answer only to the main question!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.