First published on TECHNET on Apr 05, 2017
Previously I posted a
for configuring reporting service point for “HTTPS” in ConfigMgr, but I have seen sometime people getting confused due to Certificates and URLs configuration when they are trying to configure it for HTTP (Simple) Reporting Service Point. The goal of this blog is to provide a step-by-step guide for configuring a Reporting Services Point in System Center Configuration Manager (on HTTP).
A brief introduction
Reporting in System Center 2012 Configuration Manager provides a set of tools and resources that help you use the advanced reporting capabilities of SQL Server Reporting Services (SSRS) and the rich authoring experience that Reporting Services Report Builder provides. Reporting helps you gather, organize, and present information about users, hardware and software inventory, software updates, applications, site status, and other Configuration Manager operations in your organization. Reporting provides you with a number of predefined reports that you can use without changes, or that you can modify to meet your requirements, and you can create custom reports.
SQL Server Reporting Services
SQL Server Reporting Services provides a full range of ready-to-use tools and services to help you create, deploy, and manage reports for your organization and programming features that enable you to extend and customize your reporting functionality. Reporting Services is a server-based reporting platform that provides comprehensive reporting functionality for a variety of data sources. Configuration Manager uses SQL Server Reporting Services as its reporting solution. Integration with Reporting Services provides the following advantages:
Uses an industry standard reporting system to query the Configuration Manager database.
Displays reports by using the Configuration Manager Report Viewer or by using Report Manager, which is a web-based connection to the report.
Provides high performance, availability, and scalability.
Provides subscriptions to reports that users can subscribe to; for example, a manager could subscribe to automatically receive an emailed report each day that details the status of a software update rollout.
Exports reports that users can select in a variety of popular formats.
In this example, we will use a scenario where my Report Server, SSRS (SQL Server Reporting Services) is locally hosted and the ConfigMgr Site Database is also located locally. However, you can have your Report Server at a Remote Site Server as well.
Verify and make sure that Report Server version and SCCM Database version is same, just to make sure that we don’t have any SQL compatibility issues.
Open Reporting Services Configuration Manager Console and check the version of SQL Report Server
Configuration of Report Server Database
Go to “
” tab on ‘Reporting Services Configuration Manager Console’
If the Database is already created and configured at the time of SQL Reporting Service feature installation then skip this part (Database Configuration), else proceed accordingly for configuring the Report Server Database.
In my case the Database named “ReportServer_new” is already created and configured but I am proceeding with configuration of a New Database just so that you can see how this is done.
Click on ‘Change Database’
Select “Create a new report server database” and click ‘Next’
Provide the server name where the SCCM Database instance is hosted and click on ‘Next’
Provide the name of Report Server Database you want to create. Here I have provided the name “ReportServer.”
Provide the credentials as per your environment configuration. I suggest “Local System” as a good one to use.
Click ‘Next’ to complete the configuration.
Click ‘Finish’ to complete
Once the Report Database is created you can verify the same by opening the SQL Management Console on the Site Database Server:
Configuration of URLs
Go to “Web Service URL”. You will find that the URL is already created on Port:80 but is not active. To make it active click on “Apply”.
Once you click on ‘Apply’, it will be Active and will appear like below:
Go to “Report Manager URL” and do the same.
Both URLs are Active now. Browse the ‘Web Service URL’ to make sure it is working.
Installation of the Reporting Services Point role
Go ahead and add the ‘Reporting Service Point’ Role on the Server hosting SQL Reporting Services. In my case it’s the Primary Site Server.
While adding the role make sure that you specify the following:
“SCCM Site Database Server Name”
at ‘Site Database Server Name’ (Example: PRI1.contoso.local)
“SCCM Site Database Name”
at ‘Database Name’ (Example: CM_PRI)
“Reporting Service Instance Name”
at ‘Reporting Services Server Instance’ (Example: MSSQLSERVER)
Below is the screen shot for the same:
Once the role is added you can verify the initiation of role installation and start of the Bootstrap Service in Sitecomp.log