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
