Setup Configure SCCM CB Reporting Services Point

2

SCCM has rich capabilities to collect lots of information from endpoints. This information is stored in SCCM SQL DB. We can make beautiful reports with the data collected by SCCM. SCCM has near about 500 default of reports those are available out of the box. To get access to these default SCCM reports, you need to Setup Configure SCCM CB Reporting Services point.

I have uploaded a video tutorial to cover the following topics of SCCM CB Reporting Services point. You can refer to the video tutorial from here. I have a previous blog post which has all the list of default SCCM 2012 reports “List of SCCM 2012 Default Reports“.

Check SQL Reporting Services Configuration Manager (Pre Requisite)
SCCM CB Reporting Services Point Installation and Configuration
SCCM CB Reporting Services Point Log Files
Check the Results- Launch SCCM CB SSRS Default Reports
SQL ReportServer DB Overview

Check SQL Reporting Services Configuration Manager

Prerequisite 

SQL Server Reporting Services (SSRS) is one of the requirements for SCCM CB reporting services point. The SQL reporting service is part of SQL server installation. Make sure that SSRS component is installed before going to the next step.

Architecture

The reporting services point in SCCM communicates with SSRS to copy SCCM reports to a specified report folder. SCCM will configure Reporting Services general and security settings. Reporting Services connects to the SCCM site DB to retrieve data that is returned when you run reports.

SQL Server Reporting Services Configuration Checks

Login to SQL server (or the primary server where the SQL management console is installed) and Launch SQL Server Reporting Services Configuration Manager from Start menu click All Programs, click Microsoft SQL Server 2014.

"C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\RSConfigTool.exe"

SCCM CB Reporting Services Point

Connect to the SQL Report Server Instance. Make sure report service status is in the started stage. If not started, click on START.

SQL Server Instance:          MSSQLServer
     Instance ID:             MSRS12.MSSQLSERVER
     Edition:                 ENTERPRISE EDITION
    Product Versions:         12.0.4100.1
Report Server Database Name:  ReportServer
Report Server Mode:           Native
Report Service Status:        Started 3.

Make sure the reporting server service account is configured correctly. Make sure all the following sections are precisely set up. You can have more details in the YouTube video (here).

Web Service URL
Database
Report Manager URL
E-mail Settings
Execution Account
Encryption Keys
Scale-out Deployment

SCCM CB Reporting Services Point Installation and Configuration

Launch SCCM CB console and navigate via \Administration\Overview\Site Configuration \Servers and Site System Roles. Select the Site system – Add Site System role. In the Add new site system role wizard select “Reporting services point” role. Reporting Services Point page configurations:-

Site Database Server Name: SQL_Server_Name\SQL_Instance_Name
Database Name: CM_TP1
Folder Name: ConfigMgr_TP1
Reporting Services Server Instance: MSSQLSERVER (Default instance)
Reporting Services Point Account:Intune\anoop

Following is the main configuration page for SCCM reporting services point. Click on VERIFY button to confirm the connectivity with the SQL server and access rights. Click NEXT – NEXT and finish the wizard.

SCCM CB Reporting Services Point

Check SCCM CB Reporting Services Point Log Files

Once the SCCM CB reporting services point installation wizard is completed, you can check and confirm the success of the installation of log files.

The first log I would prefer to look at is srsrpsetup.log and make sure following lines are present at the end of the log file.

Cannot delete old installation directory C:\Program Files\SMS_SRSRP. Error Code=5. Installation will continue.
No versions of SMSSRSRP are installed. Installing new SMSSRSRP.
No versions of SMSSRSRP are installed. Installing new SMSSRSRP.
Enabling MSI logging. srsrp.msi will log to C:\Program Files\Microsoft Configuration Manager\logs\srsrpMSI.log
Installing C:\Program Files\Microsoft Configuration Manager\bin\x64\srsrp.msi SRSRPINSTALLDIR="C:\Program Files\SMS_SRSRP" SRSRPLANGPACKFLAGS=0 
srsrp.msi exited with return code: 0
Installation was successful.
Installation was successful.
~RoleSetup().

The next stage in the SCCM CB reporting services point installation verification is with srsrp.log. This log will be going to take 5 minutes to complete the creation of all the default reports in SCCM. You can see all the report and folder creation details in this log file.

Successfully created srsserver~ $$<SMS_SRS_REPORTING_POINT><02-27-2018 12:11:41.899-330><thread=6168 (0x1818)>
Reporting Services URL from Registry [http://sccmtp1/ReportServer/ReportService2005.asmx]~ $$<SMS_SRS_REPORTING_POINT><02-27-2018 12:11:42.049-330><thread=6168 (0x1818)>
Reporting Services is running $$<SMS_SRS_REPORTING_POINT><02-27-2018 12:11:42.073-330><thread=6168 (0x1818)>
Retrieved datasource definition from the server. $$<SMS_SRS_REPORTING_POINT><02-27-2018 12:11:42.120-330><thread=6168 (0x1818)>
Retrieved datasource definition from the server. $$<SMS_SRS_REPORTING_POINT><02-27-2018 12:11:42.340-330><thread=6168 (0x1818)>
[SCCMTP1.Intune.com] [CM_TP1] [ConfigMgr_TP1] [SCCMTP1.INTUNE.COM]~ $$<SMS_SRS_REPORTING_POINT><02-27-2018 12:11:42.358-330><thread=6168 (0x1818)>
[MSSQLSERVER] [1] [] [INTUNE\anoop]~ $$<SMS_SRS_REPORTING_POINT><02-27-2018 12:11:42.480-330><thread=6168 (0x1818)>
[1] [0]~ $$<SMS_SRS_REPORTING_POINT><02-27-2018 12:11:42.603-330><thread=6168 (0x1818)>
Confirmed version [12.0.4100.1] for the Sql Srs Instance. $$<SMS_SRS_REPORTING_POINT><02-27-2018 12:11:43.024-330><thread=6168 (0x1818)>

Check the Results – Launch SCCM CB SSRS Default Reports

Let’s wait for sometime before launching the report server URL to check the availability of SCCM default reports. You can confirm whether the report creation process is completed from the above log file.

There are two methods to access the SCCM SSRS reports:-

1. Launch the reports from the web browser (http://sccmtp1/ReportServer/) 
2. Launch reports from SCCM Console via \Monitoring\Overview\Reporting\Reports

You can see more details, and video experience of accessing SCCM SSRS reports in the following video tutorial here.

SCCM CB Reporting Services Point

SQL ReportServer DB Overview

I have gone through all the default configuration of ReportServer DB for SCCM SSRS in the following video.

Resources:-

Configuring reporting in System Center Configuration Manager – here

2 COMMENTS

  1. I Tried to Make this configuration with a SQL Server 2017 Reporting Services. CM is running in one server and SQL Server 2017 with Reporting Services is in another Server. All firewall ports are open and SCCM Admin account is part of administrators on SQL Server. It ends up failing with a 7402 code indicating that could not monitor SQL Server. Can you help me?

  2. Hi, Thanks for the excellent guide. Is it best to install the reporting services role on the SQL Server or on your primary server if you are a 0-2000 endpoint organization and have a remote SQL box?

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.