Go into the Administration node > security> security roles and look at what you have set for permissions on your reporting role. Should look something similar to: [cid:[email protected]]
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 ________________________________ CONFIDENTIALITY NOTICE: This email contains information from the sender that may be CONFIDENTIAL, LEGALLY PRIVILEGED, PROPRIETARY or otherwise protected from disclosure. This email is intended for use only by the person or entity to whom it is addressed. If you are not the intended recipient, any use, disclosure, copying, distribution, printing, or any action taken in reliance on the contents of this email, is strictly prohibited. If you received this email in error, please contact the sending party by reply email, delete the email from your computer system and shred any paper copies. Note to Patients: There are a number of risks you should consider before using e-mail to communicate with us. See our Privacy & Security page on www.henryford.com for more detailed information as well as information concerning MyChart, our new patient portal. If you do not believe that our policy gives you the privacy and security protection you need, do not send e-mail or Internet communications to us.
