Tuesday, 19 March 2013

ConfigMgr 2012 / SCCM 2012 SP1 Step by Step Guide Part 14: SQL Reporting

Back to main menu

Part 14 describes the configuration of SQL reporting in Config Mgr 2012. I will also show a sample report and how to export the report to PDF and xls files.

Navigate to Administration/Site Configuration/Servers and Site System Roles
Right click server and choose Add Site System Roles

Add Site System Roles wizard starts

Verify server name

Enter Proxy details if required - not required in this deployment. 

Select Reporting Service Point

Verify database details

Click next to add the Reporting Service Point

Reports are now available in Monitoring/Reporting

See sample report

Click on the drop down arrow to choose file format 

Sample PDF

Sample Excel file


  1. Wow that was unusual. I jusst wrote an incredibly long comment but aafter I clicked submit mmy comment didn't appear.

    Grrrr... well I'm not writing alll thatt over again.
    Anyhow,just wanted to say wonderful blog!

    Also visit my web-site; master resale rights selling your scribd Free work At

  2. Appreciate this post. Will try it out.

    Also visit my weblog jailbreak ipod 4 6.1.3 evasion

  3. You ought to take part in a contest for one of the most useful ssites
    online. I am going too highly recommend this website!

    Feel free to surf to mmy blog ... thrombosed hemorrhoid treatment during pregnancy

  4. Hmm iѕ anyone elѕ&X65; having problemѕ wit&X68; thе
    images on this blog lo&X61;ding? I'm trying tο determine i&X66; its a problem on &X6d;y end or if it's
    the blo&X67;. Any response&X73; would be gгeatlу appreciateԁ.

    Feel free to visi&X74; mу web-site; Hostgator Helmet Cam Review Wordpress

  5. Gerry,

    I really appreciate your help. May the fruits of your labor and help come back to you bountifully. The Reporting Services server instance: is not showing my MSSQLServer. Do you know why this is the case; actually it's not giving me any option.


    1. Thanks Charles.

      Remember you have to add the Reporting Point role to the SQL site system (not the Primary Site Server).

  6. Have you heard or installed 2012 R2 with the Primary and CAS in a SQL Cluster getting reporting point working?

    1. I ALWAYS insist of local SQL to avoid this kind of problem.

  7. software metering reports can't seem in sccm 2012 r2

  8. Hi Gerry,
    Whn i enable the reporting point, the instance is blank. i installed SRS, configured it and still the same prbm. any help is appreciated.

    1. You haven't given enough information Surya. Is this local or remote SQL? Is your installation account local administrator of the SQL server and sysadmin role in SQL?

  9. Hi Gerry,
    Thanks for the response. Its a remote SQL. Yes, the install account is a sys admin in SQL and is a local admin of the SQL.

  10. I am unable to enable the reporting point in my primary site server, however the same is possible when i try to create reporting point in sql server. Does this make sense?

  11. Hi Gerry, Yes it is a remote SQL on a CLSUTER and the account is provided sysadmin role in SQL

    1. SSRS is not cluster aware. It must be configured as a scale-out solution. Have you done this? You can find good information about this here:


    2. Also your problem could be that your virtual directories have not been created in IIS. Have a look


  12. Hi Gerry,

    The issue is resolved. Missed the simplest of things. my SMS_executive service was in stopped state. Do not how or why it was stopped. However once that is started, all the reports are now in my console.
    Thanks for all your help.