So I'm just getting back to this now both Jeff and Greg have helped flush this out. You need to make sure that the users accessing the SSRS site are assigned to the Reporting Role that you created and that you assign them access to the collections they need access too.
This blog/video might help out. http://be.enhansoft.com/post/2013/10/21/Role-Based-Administration-(RBA)-Reporting-Feature-in-SCCM-2012-R2.aspx From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Tuesday, January 6, 2015 6:50 AM To: [email protected] Subject: RE: [mssms] SCCM 2012 reports not running for standard user Garth, thanks for the response. Hopefully this is what your this is what you are talking about.... Within the properties for the Reporting Services Point role, I have a user name set. It is an Active Directory account. When I check the rights for that account against the ReportServer database, it has db_owner, public and RSExecRole role membership. Against the CM database, the account has public and smsschm_users role membership. Against the Master database it has Public and RSExecRole role membership. Against the ReportServerTempDB database it has db_owner, public and RSExecRole role membership. It this what you were referring too? Paul From: Garth Jones <[email protected]<mailto:[email protected]>> To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Date: 01/05/2015 05:58 PM Subject: RE: [mssms] SCCM 2012 reports not running for standard user Sent by: [email protected]<mailto:[email protected]> ________________________________ If you are not seeing any data it is most likely because of how RBA is setup. How exactly did you setup the reporting role? From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of [email protected]<mailto:[email protected]> Sent: Monday, January 5, 2015 12:05 PM To: [email protected]<mailto:[email protected]> Subject: [mssms] SCCM 2012 reports not running for standard user Hi, I am having an issue running reports from the SQL Server Reporting Services URL. I have two accounts, an elevated account the is part of Domain Admins and has the "Full Administrator" security role within SCCM 2012 and a standard user account that has no domain privileges. My standard account though is part of an AD group for SCCM reporting that I am trying to grant privileges to run reports. If I start IE with my standard account, none of the drop downs (for Collection , etc) populate. Thought if the report has no drop downs iI will get the report headign information but no data. If I start IE with my elevated account I can run reports fine. Based on Google searches, I have added the following security to the "Report Viewers" Security role: 1. set Read permissions to Yes for Site 2. set View Asset Intelligence to Yes for Software Titles Note: this did not fix the issue I have granted the AD group datareader permissions on the SCCM SQL Server and REportign server databases...this did not work. Just to check, I granted the group "SysAdmin" privileges to the databases..did not work either and have since removed. Anyone have any idea what set of permissions I am missing? Thanks and Happy New Year, Paul
