Download and own this SCCM Installation Guide in a single PDF file.

The PDF file is a 162 pages document that contains all informations to install and configure SCCM Current Branch. Use our products page or use the button below to download it .

Download


Icon Info

This blog post has been updated. Please refer to the new SCCM Current Branch Installation Guide.

In this part of SCCM 2012 and SCCM 1511 blog series, we will describe how to install a SCCM 2012 or SCCM 1511 reporting services point.

This role can be installed on a remote machine, the process is the same but the logs location is different.

Requirements

Before you can install the reporting services point role you must configure SQL correctly.

We’ll be using SQL 2012 on this post. We are assuming that SQL is already installed and that your SCCM site is up and healthy.

During the initial SQL installation, you must select Reporting Services.

If you have installed SQL Server, but have not installed Reporting Services follow the following steps. If Reporting Services is already installed, skip to the “Configure Reporting Services” section.

  • Launch the SQL Server 2012 installation from the media.
  • Click the Installation link on the left to view the Installation options.
  • Click the top link, New SQL Server stand-alone installation or add features to an existing installation.

sccm 2012 reporting services

  • Follow the SQL Server Setup wizard until you get to the Installation Type screen.
  • Select Add features to an existing instance of SQL Server 2012.
  • Click Next to move to the Feature Selection page.

sccm 2012 reporting services

  • Select Reporting Services – Native

sccm 2012 reporting services

  • At the Reporting Services Configuration page
  • Select Install Only

sccm 2012 reporting services

Continue through the wizard and reboot the computer at the end of the installation if instructed to do so.

Configure Reporting Services

Before configuring the reporting point, some configuration needs to be made on the SQL side. The virtual instance needs to be created for SCCM to connect and store its reports.

If you installed Reporting Services during the installation of the SQL Server instance, SSRS will be configured automatically for you. If you install SSRS later, then you will have to go back and configure it as a subsequent step.

To configure, Open Reporting Services Configuration Manager

  • Click Start > All Programs > Microsoft SQL Server 2012 > Configuration Tools > Reporting Services Configuration Manager

sccm 2012 reporting services

  • Click Connect to connect to the SQL instance

sccm 2012 reporting services

  • On the left-hand side of the Reporting Services Configuration Manager, click Database.
  • Click the Change Database button

sccm 2012 reporting services

  • Select Create a new report server database and click Next

sccm 2012 reporting services

This wizard creates two databases: ReportServer, used to store report definitions and security, and ReportServerTempDB which is used as scratch space when preparing reports.

  • Click the Web Service URL tab
  • Click Apply

sccm 2012 reporting services

This step sets up the SSRS web service. The web service is the program that runs in the background that communicates between the web page, which you will set up next, and the databases.

  • Select the Report Manager URL
  • Accept the default settings and click Apply.

sccm 2012 reporting services

If the Apply button was already grayed out, this means the SSRS was already configured. This step sets up the Report Manager web site where you will publish reports

Exit Reporting Service Configuration Manager.

Add role in SCCM

  • Open the SCCM console
  • Navigate to Administration/Site/Configuration/Servers and site System Roles
  • Right click on your Site Server and click Add system Roles

sccm 2012 reporting services

  • On the General tab, click Next

sccm 2012 reporting services

  • On the Proxy tab, Click Next

sccm 2012 reporting services

  • On the Site System Role, select Reporting Services Point, Click Next

sccm 2012 reporting services

  • On Reporting Services setting tab
  • Click Verify
  • At the bottom, Add an account to use for the reporting point. This account needs to have access to the SCCM DB
  • Click Next

sccm 2012 reporting services

  • Wait for the process to complete and close the wizard

Recovery Model
Using the simple recovery model improves performance and saves your server hard drive and possibly large transaction log file.

To change the Recovery Model of the ReportingDB to Simple

  • Open SQL Management Studio
  • Right click on the ReportServer database and select Properties
  • Go to the Options page
  • Under Recovery model select Simple
  • Click OK

3222 (23)

Verify

Log
Check for the following logs for reporting point installation status. Both logs are under the SCCM logs file locations.

  • Srspsetup.log
  • Srsrpmsi.log

If your reporting point is installed on a remote server look for the logs in :

Drive:\SMS\Logs\

Console

Open Monitor/Reporting/Reports node. Verify that your reports are listed

Web Browser

Open Internet Explorer, navigate to http://yourservername/Reports

If everything went well, you’ll have a folder Config_SiteCode containing your reports

sccm 2012 reporting services

SQL

If you check your SQL instance, you’ll see the 2 new database which were created by the installation.

  • Open SQL Management Studio
  • Locate ReportServer and ReportServerTempDB

sccm 2012 reporting services

Happy reporting ! 🙂

sccm 2012 reporting services

Comments (22)

Vincent DiNenna

04.08.2020 AT 03:02 PM
Hi, Problem with SQL Reporting Services link. When selecting the Report Manager http://[server]/reports link, the page comes up blank. The Report Server link opens OK. Same happens with three different browsers. Running CM version 1806 Any ideas? Thanks, Vince

Aks

04.11.2019 AT 08:22 AM
I have SCCM 2012 1802 on sever A and and SQL server 2017 on Server B when I try to add the reporting point in SCCM I get the "unable to locate any configured SRS instance on the server. Verify SRS is installed, accessible and correctly configured" with SQL2017 we have to download the reporting services installer to install. Its no part of the set up as a feature. any ideas? Thanks Aks

Khawar Rizvi

09.23.2018 AT 04:32 AM
Hi We need to upgrade our sccm to 1806 but the reporting server ' s O/S is 2008 R2 and preqs have failed. Is it possible to uninstall RSP role upgrade sccm to 1806 then upgrade reporting server os to 2012 and then reinstall reporting server

Brando

04.04.2018 AT 01:13 PM
Might have answered my own question. In the tutorial it assumes there is (1) server that houses both the SCCM server and SQL server. In my setup I have (2) servers that split these roles. I right clicked on my SQL server and tried to install the role there. This time it picked up the server instance (MSSQLSERVER). Wondering if this is the right behavior and if it should be installed on this server?

Brando

04.04.2018 AT 12:14 PM
Experiencing the same issues as Carlos G. Went through the guide and configured everything in SQL, but when I go to add the role in SCCM there is nothing listed under "Reporting Services Server Instance". Have the exact same setup SCCM 1710 w/ SQL 2016. Any suggestions? BC

Carlos G.

03.23.2018 AT 09:27 PM
Hi guys!... Im trying to install Reporting Services Point in SCCM 1710 running on a Win Server 2016, also have my SQL 2016 in another Win Server 2016 Box... Im having the same issue, No SRS Reports showing up in SCCM Reporting Services Point installation Wizard... Any Ideas?? Thanks in advance!!

Amol Bhatt

03.16.2018 AT 04:00 AM
Hi All, I am unable to view Windows 10 dashboard available in SCCM 1710. I need to make it clickable so i can check which users are having version of Windows 10. I am referring to Windows 10 Dashboard.

Jonathan Lefebvre

03.16.2018 AT 08:19 AM
Hi Amol, the built-in dashboard is not clickable unfortunately. May I suggest you take a look at our Windows 10 report? https://systemcenterdudes.com/sccm-windows-10-report/ Jonathan

KikeRon

11.23.2017 AT 03:13 PM
I do not know how to speak or write English very well, I will try to explain myself in the best way: I have a problem with the reports services and it is not opening, I would like to know how I can solve this problem and the necessary steps for that, I appreciate all the help you can give me.

Paul Cairns

09.05.2017 AT 08:07 AM
Hi, Thanks for the post, I read it through and followed every step, however, when I try to add reporting services I get to the point where I need to add the SRS server instance, but it is just blank, also I cannot browse to the Report urls from Reporting services Configuration Manager, I seem to remember reading somewhere about certain services that must be enabled and running. I have SCCM 2012r2 CU5 on Win server 2012r2 with a separate SQL 2012 running on Server 2012r2. Any ideas?

NotNirmal

08.18.2017 AT 09:04 AM
Hello Team, We have an scenario here. SSRS installed with SQL 2008 R2 on remote server and configured RSP. Also, we have upgraded our SCCM site database to SQL 2016 and migrated all our DBs. Now, we need to migrate SSRS to SQL 2016 (also, OS to be upgrade from Server 2008 to Server 2012 R2) and use existing DBs Report Server and ReportServerTempDB. Kindly suggest the best way to achieve this

Paul Cairns

08.18.2017 AT 03:50 AM
Guys, Thanks for the post, it has been a life saver and has saved me such headaches. Awesome work.

sccm

11.26.2016 AT 02:48 AM
why do you use small pictures? it is a bad idea.

Gary S

05.27.2016 AT 07:57 AM
Dudes, In SRS installation section, your "Install Only" screenshot shows installing in Sharepoint Integrated mode... I think you want to show the middle option, no?

Reo87

04.27.2018 AT 10:56 AM
Yeah I was thinking the same thing.

Court

05.18.2016 AT 04:06 PM
Hello, Thanks for the information above. I have a quick question about the reporting services point role. Can it only be installed on a site that has SSRS installed? ie. If I have SSRS on different server (SQL) can I have the reporting services point on my primary site, and just point to the SSRS instance on the other server?

Adam

02.11.2016 AT 05:14 PM
Hallo Nick my Reporting Server was working. I'm now receiving error 500 with access denied. It seems that .Net Framework 4 update issue. How ca I fix it? Thanks a lot Adam

P DEV

02.26.2015 AT 09:47 AM
Hello, I am struggling in SCCM 2012 Reporting, Just two days ago , our reporting service was working and now whole contents from web console as well as actual console is missing, I do not know what happened, when I look at properties for Reporting Service Point -- Database is CM_XXX, is it supposed to be that or SCCMReport? in Reporting Service Configuration -- Database is connect to SCCMREPORT, I am so confused with this one, Can you help? PD

Nicolas Pilon

03.05.2015 AT 01:37 PM
Hi Dave, Reporting Service Point - Database is the SCCM database connection. Normally, it is CM_XXX. Reporting Service Configuration - Database is the reporting service database. In your case is SCCMReport. By default, it is ReportServer. SCCM database is used to execute report. SSRS database is used to see statistics, inventory, subscription of your reporting services. Thanks Nick