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]> To: "[email protected]" <[email protected]> Date: 01/05/2015 05:58 PM Subject: RE: [mssms] SCCM 2012 reports not running for standard user Sent by: [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]] On Behalf Of [email protected] Sent: Monday, January 5, 2015 12:05 PM To: [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
