ConfigMgr Console

Building a ConfigMgr Lab from Scratch: Step 12 – SQL Reporting Services (SSRS)

Topics: ConfigMgr Console

Building a ConfigMgr Lab from Scratch: Step 12

SQL Reporting Services (SSRS)

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.

If you’re a Right Click Tools Enterprise customer, we have some great dashboards and reporting built in, which makes surfacing the data quite easy, right in the console. Just a quick shameless plug, because I really like our dashboards. [More Info]

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:

SQL Server installation Center
On the Installation Tab, chose “Install SQL Reporting Services” That will launch your browser to:
Install SQL Server Reporting Services
Click “SQL Server 2019 Reporting Services” download
Microsoft SQL Server Reporting
Download
Microsoft SQL Server Reporting Services
Click on Install Reporting Services
Microsoft SQL Reporting Services
For my lab, I’m using the Developer Edition, of course, if you’re using this in production, enter your product key
Microsoft SQL Server Reporting Services
Sure, I accept
Microsoft SQL Server Reporting Services
Next
Microsoft SQL Server Reporting Services
and now we watch the progress bar….
Microsoft SQL Server Reporting Services
Ok, let’s Configure report server
Report Server Configuration Manager
Yes, Connect, thank you very much
Report Server Configuration Manager
Click Apply to set up the Virtual Directory
MEMCM SQL Server Reporting Services
And confirmation that it is set up…
Report Server Configuration Manager
Time to create the Database
Report Server Configuration Manager
Report Server Configuration Manager
Report Server Configuration Manager Database
Report Server Configuration Manager Database
Report Server Configuration Manager Database
Report Server Configuration Manager Database
Report Server Configuration Manager Database
in the Web Portal URL, click Apply
Report Server Configuration Manager Web Portal
Alright, now we should be done getting it configured, let’s confirm the database.
MEMCM Virtual Machine Connection
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]

Microsoft SQL MEMCM
Add Site System Roles Wizard
Add Site System Roles Wizard
Choose Reporting Services Point
Add Site System Roles Wizard
Here is where you added the SSRS Service account that you set up.
Add Site System Roles Wizard
Add Site System Roles Wizard
Ok… and now it is set up.

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

Site Status
SQL Server Reporting Services
Excellent!
SQL Server Reporting Services
Look at that nice report.

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


Building a ConfigMgr Lab from Scratch Series

Series Introduction – Building a CM Lab from Scratch

  1. Setting up your Domain Controller
  2. 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 – You are Here
  13. Cloud Management Gateway (CMG) – Certs PreReq
  14. Cloud Management Gateway (CMG) – Azure Subscription
  15. Azure Services Connection
  16. Setting up CMG in the Console
  17. Cloud Management Gateway (CMG) – Post CMG Config
  18. Cloud Management Gateway – Client CMG Endpoints
Back to Top