This post is part of SCCM Current Branch Installation Guide series

In this Post we are going to install the role “Reporting Services Point”. By installing this role, we can run hundreds of in-build reports to check various status of deployments, inventory, client status etc.

Launch SCCM Console and navigate to Administration \ Overview \ Site Configuration \ Servers and Site System Roles

On Right Pane, you will be able to see Site Servers. Select the Server, right click and select “Add Site System Roles” to open the Site System Roles Wizard. Select next to continue.

RoleSSRS01

Under Proxy Page, select next to continue.

RoleSSRS02

Under “Site Role Selection“, you will see list of roles available to install on server. Check the box “Reporting services point” and click next.

RoleSSRS03

This is the most important page for reporting Service point installation. Make sure current Database name is mentioned. Click on verify to confirm.

Under “Reporting Services Server instance”, it should show SSRS as we previously installed SQL Server Reporting Services with instance name SSRS.

Select existing or new username which will be used to connect SQL Reporting Services to SCCM Database.

RoleSSRS04

Click next, confirm the settings to complete the installation.

RoleSSRS06

Verify following logs for successful installation of role:

  • srsspsetup.log : To verify exit code 0 is returned.
  • srsspMSI.log : msi installation of reporting point installation to verify exit code returning 0.
RoleSSRS07 1

Verify another log file as well (srsrp.log) which will show list of all reports getting installed.

RoleSSRS08 1
RoleSSRS09

Once installation is completed, launch SCCM console, navigate to Monitoring \ Reporting. On Right Pane, you will be able to see following links

Report Manager : http://sccm01/Report
Report Server : http://sccm01/ReportServer.

Click on Report Manager link to launch the reports.

RoleSSRS10

This will launch the web URL for reporting services where you can browse all kinds of reports specified under various categories.

RoleSSRS11