Building a CM Lab - SQL Reporting Services (SSRS) [12]

In post 12, we'll cover reporting.

So you've got your CM Server and some clients, now you want to surface that data via reporting. [MS Docs] Sure Power BI is cool, but who has money for that, SSRS is included and there are some pretty nifty free reports in the community.  In this post, we're going to be installing SSRS 2019, along with getting it configured then installing the Reporting Service Role in ConfigMgr. [SSRS 2019 Download Link]

Requirement: SQL Service Account setup in AD (CM_SSRS), in SQL_Admin Group (Which has admin rights to SQL, see the SQL Install Post for more info)

First, I launched the SQL Server Setup from the start menu:

On the Installation Tab, chose "Install SQL Reporting Services" That will launch your browser to:
Click "SQL Server 2019 Reporting Services" download
Click on Install Reporting Services
For my lab, I'm using the Developer Edition, of course if you're using this in production, enter your product key
Sure, I accept
and now we watch the progress bar....
Ok, lets Configure report server
Yes, Connect, thank you very much
Click Apply to setup the Virtual Directory
And confirmation that it is setup...
Time to create the Database
in the Web Portal URL, click Apply
Alright, now we should be done getting it configured, lets confirm the database.
You can launch MS SQL Server Management Studio and you'll see the new ReportServer databases

So now that we've Installed SSRS and had it configured, we can add the Reporting Role... so in the CM Console, the Administrator Tab [MS Docs]

Choose Reporting Services Point
Here is were you add the SSRS Service account that you setup.
Ok... and now it is setup.

So now I've waited a bit, had dinner and came back to check things out..

Look at that nice report.

If you setup the Certificate Authority, you can then add a cert and make this HTTPS... if you want.

Blog Post List

Series Introduction - Building a CM Lab from Scratch

  1. Domain Controller - Setting up your Domain Controller
  2. Gateway Virtual Machine - Creating a Router for your Lab using Windows Server
  3. Certificate Authority - On Domain Controller [Optional]
  4. ConfigMgr Server Pre-Reqs (Windows Features)
  5. Configuration Settings (AD & GPOs)
  6. Source Server (File Share)
  7. ConfigMgr SQL Install
  8. ConfigMgr Install
  9. ConfigMgr Basic Settings
  10. ConfigMgr Collections & App Deployment
  11. ConfigMgr OSD
  12. ConfigMgr Reporting Services