SystemCenter

All about System Center Articles and Tutorials

Configure Reporting Services & Install Reporting Services Point Role – Configuration Manager

Posted by on Jul 5, 2017 in SCCM, SQL

Configure Reporting Services & Install Reporting Services Point Role – Configuration Manager

System Center Configuration Manager provides Reporting feature using advanced reporting capabilities of SQL Server Reporting Services (SSRS). It uses SQL Server Report Builder as the exclusive authoring and editing tool for model-based and SQL-based reports through which we can author desired reports to gather, organize and present the information about users, hardware, software inventory, updates, applications, site status and other Configuration Manager operations in our organization.

In this article, we will configure SQL Server Reporting Services and install Reporting Services Point Role in our System Center Configuration Manager environment so we can use and extend the comprehensive Reporting functionality which SCCM provides.

Before we start, please refer Microsoft TechNet Article Reporting Services Configuration Manager (SSRS) to have a basic understanding about SSRS.

Let’s start…

Configure SQL Server Reporting Services

1: Open Reporting Services Configuration Manager on SCCM DB Server.

2: Connect to the Report Server Instance by selecting the Server Name on which report server instance is installed.

3: Click on Service Account tab.

4: Select Use another account option under Report Server Service Account box.

5: Provide the service account credentials and click Apply button.

Make sure you get The task completed successfully message under Results box.

6: Click on Web Service URL tab.

7: Click on Apply button to active the Report Server Web Service URL.

Make sure you get The task completed successfully message under Results box.

8: Click on Database tab and click Change Database button.

9: Choose Create a new report server database option and click Next.

10: Click on Test Connection button.

You should get Test Connection Succeeded message.

11: Click OK and Next button to proceed.

12: Leave the Database Name to default ReportServer.

13: Click Next button to continue.

14: Leave the options to default and click Next button.

15: Review the Summary and click Next button.

16: Database configuration should end with Success messages, click Finish button to close the wizard.

Now the Database tab should show the configured Report Server Database and Credential information.

Make sure you get The task completed successfully message under Results box.

17: Click on Apply button to configure Web Portal URL.

Make sure you get The task completed successfully message under Results box.

18: Click on Execution Account tab.

19: Specify the service account credentials and click Apply button.

20: Click on Encryption Keys tab and backup the Encryption Key by clicking Backup button.

21: Click on Scale-out Deployment tab.

Make sure the Scale-out Deployment Status should be Joined.

Reporting Service Configuration is complete, now let’s test the URLs.

Click on Web Service URL tab and click on the Web Service URL.

The Web Service URL should open without any error.

Let’s check the Web Portal URL as well.

Click on Web Portal URL tab and click on the URL.

The Web Portal URL should open without any error.

SQL Server Report Services configuration and testing part on SQL Server is done. Now let’s install the Reporting Services Point role in SCCM.

Install Reporting Services Point Role

1: Open SCCM console on Primary Server.

2: Click on Administration tab and click on Servers and Site System Roles option under Site Configuration folder.

3: Right click the site and click on Add Site System Roles option.

4: Leave the options to default and click Next button.

5: Click on System Role Selection tab and select Reporting services point option.

6: Click Next to continue.

7: Check below settings and click on Verify button.

  • Site database server name
  • Database name
  • Reporting Services server instance

You should get Successfully verified message.

8: Click on Set button and provide the service account you want to use under User name field.

9: Click Next to continue.

10: Review the Summary and click Next.

Reporting services point role should be installed with Success message within few seconds.

11: Click Close button to close the Add Site System Roles Wizard.

12: Click on Monitoring tab and click on Reporting folder.

Now the Report Manager and Report Server URLs should be visible there.

If you click the Report Manager URL, you should see the folders containing reports.

SCCM predefined reports will be visible under Reports option.

You can use these reports or can create a custom report as per your requirement from here.

That’s it.

Hope this helps.

1 Comment

  1. Thank you! very helpful guide 🙂

Submit a Comment

Your email address will not be published. Required fields are marked *