In this post we will look at the steps on how to re-install SQL Reporting Services for SCCM. When you are reading this post, just understand that this post is not about reinstalling the reporting services point role, in this post I am showing you the steps for installation of SQL Reporting Services. If you have been working on SQL server, this might be easy thing for you. But a lot of Configuration Manager admins work primarily on SCCM and not on SQL. This post will help the SCCM admins who are looking to re-install the SQL reporting services.
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 Services connects to the Configuration Manager site database to retrieve data that is returned when you run reports. But sometimes the reports won’t load and after looking at logs and troubleshooting, you come to the conclusion that you need to uninstall your Reporting services point role and the SQL Reporting Services and start from scratch. Here is the step by step way to do that.
Note – Since we will installing the SQL reporting services component, ensure that you have the SQL Server Installation Media before starting this process.
We will be performing the following steps in this post :-
- Uninstall Reporting Services Point role.
- Uninstall SQL Reporting services.
- Remove/Delete SQL report server DB and log files.
- Re-Install the SQL Reporting Services.
- Configure the SQL Reporting Services.
- Re-install Reporting Services Point role.
How to Re-install SQL Reporting Services for SCCM
Uninstall Reporting Services Point role – Open the Configuration Manager console. Navigate to Administration > Site Configuration > Servers and Site System Roles. In the Servers and Site System Roles window on the right side of the screen locate the Server you need to remove the role from and select it. In the lower pane of the window (Site System Roles) scroll down until you see Reporting Services Point. Right click the Reporting Services Point, click Remove Role.
If you open the srsrp.log file, you would see the status SMS_SRS_REPORTING_POINT is signaled to stop.
Uninstall SQL Reporting services – On Server with the SQL Reporting Services installed, open the Control Panel. Navigate to Programs and Features. In the Uninstall or Change a Program list, select Microsoft SQL Server 2014 (64-bit). Click the Uninstall or Change option. On the SQL Server 2014 Dialog, click Remove.
On the Setup Support Rules Dialog, click OK. On the Select Instance Dialog, ensure the correct instance is selected and click Next.
On the Select Features Dialog, select Reporting Services – Native and click Next.
On the Ready to Remove Dialog, click Remove.
On the Complete Dialog, click Close. The next step is to reboot the server.
Remove/Delete SQL report server DB and log files – Open the SQL Server Management Studio, on the Connect to Server Dialog, verify connection settings and click Connect. Expand the Databases. Select the ReportServer DB, right click and select Tasks and then Detach.
On the Detach Database Dialog, select the Drop & Update Statistics check box and then click OK. Similarly select the ReportServerTempDB, right click and select Tasks and then Detach. On the Detach Database Dialog, select the Drop & Update Statistics check box and then click OK. Close the SQL Server Management Studio.
Open File Explorer and navigate to the folder where you ReportServer and ReportServerTempDB database files and the log files are present. Delete the ReportServer and ReportServerTempDB files and log files.
Re-Install the SQL Reporting Services – On Server that you just removed the SQL Reporting Services from, open the Control Panel. Navigate to Programs and Features. From the list of programs select Microsoft SQL Server 2014 (64-bit). Click the Uninstall or Change option and on the SQL Server 2014 Dialog, click Add.
On the Browse for SQL Server 2014 installation media, locate and select the location of the install media, then click OK. On the Setup Support Rules Dialog, click OK. On the Product Updates Dialog, click Next. On the Setup Support Rules, click Next. On the Installation Type Dialog, select Add features to an existing instance of SQL Server 2014, click Next.
On the Feature Selection Dialog, check the Reporting Services – Native, click Next. Click Next for rest of the dialog and on the Complete Dialog click close.
Configure the SQL Reporting Services – On Server you just re-installed the SQL Reporting Services on open Reporting Services Configuration Connection. On the Reporting Services Configuration Connection, click Connect. Select the Web Service URL, click Apply.
Select the Database, click Change Database button. Select Create a new report server database, click Next.
Click the Test Connection button, click Next if successful.
Click Next for the remaining dialog and click Finish at the end.
Select the Report Manager URL, click Apply. Once you click Apply, the warning message shown in the dialog should disappear.
Re-install Reporting Services Point role – The final step is to Re-install the Reporting Services Role. This is very simple, you can follow this guide to complete the installation of role.