Uninstalling & Reinstalling SQL Server Reporting Services 2012

​I had some issues with uninstalling and reinstalling Microsoft SQL Server 2012 Reporting Services in my SCCM Lab environment. It turns out there are a few steps not mentioned in the microsoft documentation that you need to do in order to do a fresh install, without carrying any configuration settings over from the previous install. Here are a few dot points on what I had to do.

  • Remove the Reporting Services Point from SCCM
  • Appwiz.cpl > Microsoft SQL Server 2012 > Remove > Remove Reporting Services
  • Manually delete the ReportServer Database and the Temp Report Server Database
  • Delete the C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER) folder.
  • Reboot
  • Reinstall SQL Server Reporting Services and select install only during the installation.
  • Open up Reporting Services Configuration Manager and configure your accounts.
  • Make sure that the Websites are set in Reporting Services Configuration Manager or you won’t see a Sql Instance when you try to create the Reporting Services point in SCCM. http://social.technet.microsoft.com/Forums/en-US/4479e73e-8a19-4c7e-9418-b36770656b9b/sccm-2012-reporting-point-server-instance-blank

 

Report Builder 3.0 Fails to Install

If you find that the Report Builder 3.0 Click Once Application fails to install, you might have the same issue I have had in this blog post.

 

I tried to create a Report in SCCM and when the ClickOnce Application for Report Builder 3.0 tried to install it got this error.

 

WOW, soo helpful, thanks Microsoft! Click on Details, and you will get some more helpful information. Scan the log file for something similar to below.

 

ERROR SUMMARY

    Below is a summary of the errors, details of these errors are listed later in the log.

    * Activation of http://<server>/ReportServer/ReportBuilder/ReportBuilder_3_0_0_0.application?http://<server>/ReportServer/ConfigMgr_MTL/Hardware%20-%20Memory/Memory resulted in exception. Following failure messages were detected:

        + Unable to install this application because an application with the same identity is already installed. To install this application, either modify the manifest version for this application or uninstall the preexisting application.

This is most likely generated because you have installed Report Builder 3.0 once before. To fix this all you need to do is to clear the Click Once Application cache. Open up a command prompt and then type the following "rundll dfshim CleanOnlineAppCache" **NOTE** this command is case sensitive, I found that I had to type it exactly.

Now try again to Create or Edit a report.

Hope this helps!