SQL Server Reporting Services is a server-based reporting platform that provides comprehensive reporting functionality for a variety of data sources.
The reporting services point in Configuration Manager communicates with SQL Server Reporting Services (SSRS) to copy Configuration Manager reports to a specified report folder to configure Reporting Services settings and to configure Reporting Services security settings.
Reporting Services connects to the Configuration Manager site database to retrieve data that is returned when you run reports.
Before we install the reporting services point in a Configuration Manager site, you must install and configure SQL Server Reporting Services on the site system that hosts the reporting services point site system role.
Before we add Reporting Service point, we need to install SQL server reporting instance then configure it.
We can install multiple Reporting Services Points throughout the hierarchy.
Prerequisites for Reporting Services Point:
· .NET Framework 3.5: Including
◦.Net Framework 3.5 (Includes .NET 2.0 and 3.0)
· .NET Framework 4.5.2
· SQL Server Reporting Services
Open SQL Server 2012 Installation media then run setup as Administrator;
Click on the Installation tab on the left, then click on New SQL server stand-alone installation or add features to an existing installation;
Setup will run the support rules again.
Any error’s must be fixed before continuing with the setup;
Enter the product key or choose a free edition then click next;
Accept the license terms then click next;
On the Setup Role window select SQL Server Feature Installation then click next;
On the Feature Selection window choose Reporting Services-Native Instance feature, keep the share feature directory on the default installation path, then click next;
On Instance Configuration page choose Default instance then click next;
Review the disk usage summary the click next;
Provide SQL Server Reporting Services account name with password then click next;
On Reporting Services Configuration select Install Only then click next;
Choose error reporting options then click next;
Setup will run Installation configuration Rules and make sure all the operations are passed;
Review the summary of configuration then click Install;
If everything configured correctly the installation will complete successfully.
Next step is to Install MS SQL 2012 SP3:
Download SQL 2012 SP3 from here https://www.microsoft.com/en-us/download/confirmation.aspx?id=49996
Run SQLServer2012SP3-KB3072779-x64-ENU as Administrator;
Install will check the applicability of the update, click next to proceed;
Agree the license terms then click next;
The installer will select the instances by itself. Accept the defaults then click next;
Wait until the Check Files In Use scan is complete then click next;
Review the summary then click on update;
The update process will take time based on the installed instances;
A installed feature status summary will be displayed on the Complete window;
On the Database tab enter the Database Name as Report Server.
Here the database name is for Reporting Server database NOT the site database, which will be created after the wizard;
On the Credentials page authentication type choose Service Credentials then click Next;
Review the summary of the selected options for Report Server Database Configuration Wizard then click Next
If everything configured correctly then the configuration of the database will complete successfully.
Go to Report Manager URL tab on the left, then click apply to configure the Report Manager URL;
(Nothing to be changed here - Clicking Apply will configure Reporting Manager URL)
Now the SQL Server Reporting Service is configured and we are ready to install Reporting Service Point.
Installing Reporting Services Point:
Launch Config Manager Current Branch console, then go to \Administration\Overview\Site Configuration\Servers and Site System Roles
Right click on Servers and Site System Roles then choose Create Site System Server;
On Select a server to use as a site system window, enter FQDN of server name where we have installed SQL Server Reporting services.
Select Use the site servers computer account to install this site system for site system installation account then click next;
If required enter internet proxy server details then click next;
Select Reporting services point role then click next;
By default the installer will pick the default values from the site database server with red exclamation marks.
Once we enter the correct SQL database (site database server FQDN) server name, we should be able to successfully verify the database name.
Also if we configured the Reporting Services configuration correctly, then the reporting services server instance also resolve the name.
Enter a username for SQL Reporting Services to communicate with the SQL Server Database then click next;
Review the summary then click next;
If everything is configured correctly then the create site system server wizard will complete successfully.
Check srsrpsetup.log under C:\SMS\Logs and the log should say Installation was successful.
Test the reports from console. The reports should start showing up slowly, first it will show only few nodes but eventually will show all.
If the reporting Services not configured as described in SQL Server Reporting Services Configuration step, you will receive "There is a problem connection to the specified reporting server. Please check the connection and make sure SQL reporting services is running on the specified server".
Configuring SQL Server Reporting Services will solve this problem.
This concludes the installation of standalone Reporting Services Point for System Center Current Branch 1511.
Click here for complete SCCM 1511 Current Branch setup step by step guide.
Click here for complete SCCM 1511 Current Branch step by step guide, step by step migration guide, step by step monitoring and health check guide and step by step SCCM Current Branch servicing guide.