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.