How to assign basic reporting permissions in Configuration Manager R2

Configuration Manager 2007 R2 offers two options when it comes to reporting. The classical reports and SQL Reporting Services. This post will explain how you assign permissions to both solutions.

Classical reports

  1. Add the user/group to the local SMS Reporting Users group on the Reporting Point

    image

  2. In the Configuration Manager console, navigate to Security and assign the User/Group Read permissions on the Reporting Class.
    image

SQL Reporting Services

  1. Open the SQL Reporting Services website http://server/reports
  2. For SQL Reporting Services 2008 R2, Click Folder Settings.
  3. For SQL Reporting Services 2008, Click Properties.
  4. Click New Role Assignment
  5. Assign the Browser role for all users/groups who requires Read permissions
    image
  6. Assign Content Manager role for all administrators
    image
  7. Click OK. The permissions are automatically published to Configuration Manager.
By | 2011-02-24T07:14:11+00:00 February 24th, 2011|Configuration Manager (SCCM)|5 Comments

About the Author:

Kent Agerlund
Microsoft Regional Director, Enterprise Mobility MVP. Microsoft Certified Trainer and Principal consultant. I have been working with Enterprise client management since 1992. Co-founder of System Center User Group Denmark in 2009. Certified MCITP: Enterprise Administrator, MCSA+Messaing, and much more. Member of: Microsoft Denmark System Center Partner Expert Team The Danish Technet Influencers program System Center Influencers Program.

5 Comments

  1. konta bankowe April 17, 2011 at 13:00 - Reply

    That’s great, I never thought about Nostradamus in the OR

  2. Shaun Ottinger August 3, 2011 at 10:01 - Reply

    I do like the way you have framed this specific challenge plus it does supply us some fodder for consideration. Nonetheless, coming from what I have witnessed, I simply just hope when other reviews pile on that people today continue to be on issue and in no way get started upon a soap box regarding the news du jour. All the same, thank you for this fantastic piece and though I do not agree with it in totality, I respect your standpoint.

  3. sawan September 20, 2011 at 17:05 - Reply

    thnx for sharing such a nice info, but kindly also clear me that I have SMS reporting user group in SQL 2008 R2 machine but didnt find any reporting admin group as mentioned in the screenshot above.

    what I did , I just add my domain admin account and allow it everything but I am getting permission issue while trying to extract the reports from SCCM 2007.

    can anyone please help me

  4. […] articles about rsconfig and Windows Impersonation but none of it seemed quite real and then a beautiful someone alerted me to ‘Folder Settings’, or maybe I figured it out myself. I can’t […]

  5. Lauren February 24, 2017 at 22:58 - Reply

    Enjoyed examining this, very good stuff, appreciate it.

Leave A Comment