Let’s learn to Install ConfigMgr SSRS Reporting Services Point. We can make beautiful reports with the data collected by the Configuration Manager. SCCM has 500+ default reports those are available out of the box and ready to use.
Before you can view or manage reports from the admin console, you need a reporting services point. . Reporting Services connects to the Configuration Manager site DB to retrieve data that is returned when you run reports.
SQL Server Reporting Services (SSRS) is one of the requirements for SCCM CB reporting services point. The SQL reporting service is part of SQL server installation. You can refer to SQL installation and SQL reporting service role installation details from the previous blog posts. 1. SQL Server – Installation 2. SQL Server Database Migration.
Reporting in ConfigMgr has the following dependencies:
- SQL Server Reporting Services
- Reporting services point
- Optional – Power BI Report Server
- .NET Framework 4.8
- SQL Server Native Client
- Other details here.
It’s not recommended to change the reporting server URL. This change can create issues when you try to access reports from the admin console.
- You also need to have appropriate SCCM permission to install the site system role.
- The user account you use to create the reporting services point must have Read access to the site database.
- The current user must have Read access to WMI on the site system.
- The account that you specify must have the Log on locally permission on the server that hosts the Reporting Services database. This is for the Reporting services point account mentioned in the below section.
Install Reporting Services Point
Let’s see how to install reporting services point.
- Launch admin console.
- Navigate to \Administration\Overview\Site Configuration\Servers and Site System Roles.
- Right click on SQL server where I’m planning to install Reporting service point.
- Select Add Site System Roles.
- Use the site server’s computer account to install the site system if the site server and site system servers are in the same domain and
- your site servers account should be added to the local administrator’s group on the remote site system servers.
- If the servers are not in the same domain and don’t have a two-way trust, try to use the next option – “Use another account for installing this site system“.
- Click on the Next button.
- Click on the Next button from Specify Internet Proxy Server page.
- Click on Reporting Services Point.
- Click on the Next button.
NOTE! – Reporting services server instance should automatically get detected. If the reporting service is not showing up by default, then you need to perform some troubleshooting with SQL Server Reporting Services Configuration Manager from the Start menu. Also, check the permissions section to get more details.
- Click on the Verify button to confirm Site Database connection settings.
- Normally Site Database server name, Database name, Folder Name, and Reporting services server instance will get automatically populated.
- Select the Reporting Services Point Account – Specify the credentials that SQL reporting Services will use when connecting to the Configuration Manager site database.
- Select the service account by clicking on the Set button.
- The permission section above should be taken care and as per that guidance use the appropriate permission.
- Click Next, Next, and Close.
Let’s see whether the SSRS reports are available or not.
- Launch Admin console
- Navigate to \Monitoring\Overview\Reporting\Reports
- Launch any particular report from console itself