How to Install a SCCM Reporting Services Point

After writing posts about, How to Install SQL Server 2017 and How to Install SQL Server Reporting Services 2017, I was surprised to learn that I hadn’t written one about how to install a reporting point for System Center Configuration Manager (SCCM) current branch. This, therefore, is the final blog post in my three-part series about how I installed SQL Server 2017 and then setup the SCCM reporting services point with SSRS 2017 in my lab.

These are the steps at a high-level:

  • First, add the site server computer account as the local administrator on the SSRS server.
  • Second, add the site server computer account as a SQL Server administrator within SQL Server.
  • Third, add the SCCM reporting services point to the site server.
  • Lastly, validate that the reporting point is working.

Background

As you probably already know, Enhansoft, where I’m the Chief Architect, specializes in using SCCM to collect extra inventory details about computer warranties, computer monitors, local administrator group names, etc. Once these details are all inventoried and returned to SCCM, our customers need to see them in easy-to-read reports. After the reports are created, we test all of them on each version of SQL Server.

Since I needed to setup SQL Server Reporting Services (SSRS) 2017 a second time (for a new reporting services point in my lab) I decided to put together a blog post series about how to install SQL Server 2017 and SSRS 2017, and then how to add the SSRS site as a reporting point in SCCM current branch.

Prerequisites

The following items are required before you can start installing the SCCM reporting services point.

  • SQL Server 2017 is installed.
  • SSRS 2017 is installed and configured.
  • The SSRS connection account is created. Read the following section for more details.
  • SCCM current branch is setup.

SSRS Connection Account

Before starting, I want to say a few words about the SSRS connection account. When you create this account in AD, grant it NO extra permissions within the domain. Please don’t make it a domain admin. All it needs is regular, low rights. Don’t even think about making it a local administrator on SQL Server or the SSRS server. Why am I saying this? SCCM takes care of granting the permissions it needs within SQL Server and SSRS.

Adding the Site Server Computer Account as the Local Administrator

SCCM Reporting Services Point - Computer Management

On the SSRS server, start by opening up Computer Management. Expand Local Users and Groups and then Groups. In the center panel, double-click on the Administrators group.

SCCM Reporting Services Point - Administrators Properties

Click Add…

SCCM Reporting Services Point - Select Users-Service Accounts-Groups

Click Object Types…

SCCM Reporting Services Point - Object Types

Select Computers and click OK.

SCCM Reporting Services Point - Check Names

Type the site server’s name with a dollar sign $ at the end of it and then click Check Names.

SCCM Reporting Services Point - OK

In the above screenshot you can see that the text of the site server’s name is now in uppercase letters and it is underlined. This indicates that the computer account was found and everything is good in order to proceed to the next step. Click OK.

SCCM Reporting Services Point - Administrator Members

Click OK and then close the Computer Management window.

Add the Site Server Computer Account as a SQL Server Administrator within SQL Server

Since I cover these steps in my blog post, How to Create a SQL Server Computer Account Login, I won’t repeat them here. Please note: this step must be completed before proceeding.

Installing the SCCM Reporting Services Point

SCCM Reporting Services Point - SCCM Console

Open your SCCM console, select the Administration workspace, expand the nodes Site Configuration and then Servers and Site System Roles. On the Home tab, select Create Site System Server.

SCCM Reporting Services Point - General Node

Click Browse…

SCCM Reporting Services Point - Select Computer

Enter the server’s name and then click on the Check Names button. Once the server’s name is underlined and in uppercase (similar to the one in the screenshot above), you will know that everything is good to go. Click OK.

SCCM Reporting Services Point - Site Code

Select your site code.

SCCM Reporting Services Point - Next

Click Next.

SCCM Reporting Services Point - Proxy Node

Click Next.

SCCM Reporting Services Point - System Role Selection Node

Select Reporting services point and then click Next.

SCCM Reporting Services Point - Specify Reporting Services Settings

Click Verify.

SCCM Reporting Services Point - Reporting Services Server Instance

Your Reporting Services server instance should be automatically selected for you.

SCCM Reporting Services Point - Set

Click Set… and then New Account.

SCCM Reporting Services Point - Windows User Account

Click Browse…

SCCM Reporting Services Point - Select User

Enter the reporting services point account name and then click on the Check Names button. Once the account is underlined and in uppercase (similar to the example in the screenshot above), click OK.

SCCM Reporting Services Point - Password

Enter and confirm the password, then click OK.

SCCM Reporting Services Point - Reporting Services Point Node

Click on the Summary node.

SCCM Reporting Services Point - Summary Node

Click Next.

SCCM Reporting Services Point - Completion Node

Click Close. With that last step completed, the SCCM reporting services point is installed. I recommend waiting around 15-30 minutes before checking that everything is setup correctly.

Validating the SCCM Reporting Services Point

There are two main tests you should perform in order to validate that the SCCM reporting services point is working properly. All you are going to do is test the URL (http://<servername>/reports) in two different locations by following the exact same steps. The details about each test are listed below.

Test 1

This test confirms that the SCCM reporting services point can access the reporting site from the SSRS server itself.

SCCM Reporting Services Point - SQL Server Reporting Services Web Page

First, on the SSRS server, browse to http://<servername>/reports. This should always work and, if it is successful, you should see a similar web page as the one shown above.

SCCM Reporting Services Point - SQL Server Reporting Services - Folders

Next, drill down on the ConfigMgr_<yoursitecode> link. You should, again, see a webpage that’s similar to the one above.

Finally, select a report and run it. In the worst-case scenario, the report shows no results, but it confirms that it is a functioning report.

Test 2

This test proves that any remote computer (from the SSRS server) can access the reporting site. Once again, you are going to perform the same steps as you did in Test 1 and the results of each step look exactly like the screenshots shown in the first test.

On a computer that is remote to the SSRS server, browse to http://<servername>/reports. If all the firewall ports are setup correctly, this test will work perfectly.

Next, drill down on the ConfigMgr_<yoursitecode> link. Again, you should see a webpage that’s similar to the one in Test 1.

Finally, select a report and run it. Ideally it’s the same report you selected in the first test, so you should see the exact same results.

Now that you validated the SCCM reporting services point, you can hand out the link to anyone who needs to view reports within SCCM.

If you have any questions about how to install the SCCM reporting services point, please feel free to contact me at @GarthMJ.

Leave a Comment

Collection Details