Reporting Point Installation
- April 21, 2022
- Posted by: Pavithra
- Category: End User Computing
Reporting Point Installation We will describe how to install a SCCM Current Branch reporting services point.
This role can be installed on a remote machine, the process is the same but the location of the logs is different.
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.
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 > Configuration Tools > Reporting Services Configuration Manager
ADD REPORTING SERVICES POINT 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
Using the simple recovery model improves performance and saves your server hard drive and possibly a 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
Check for the following logs for reporting point installation status. Both logs are under the SCCM logs file locations.
If your reporting point is installed on a remote server look for the logs in :
Open Monitor/Reporting/Reports node. Verify that your reports are listed
Open Internet Explorer, navigate to http://yourservername/Reports
If everything went well, you’ll have a folder Config_SiteCode containing your reports.
Live Instructor-led Online Training