Reinstall Reporting Services 2005

Question

We are having problems with our reporting services portion of SQL server 2005. Can someone provide some guidance for reinstalling reporting services?

Answer 1

Have you tried just removing the virtual directories from IIS and running the report configuration wizard again?

This is what I have done when our installation went wonky and not only was it quick and painless, it resolved the problem too!

NOTE: We had a security issue where no client could view the reports even when in the correct AD groups

YMMV but you could try this first before going through the entire Add/Remove Programs->Change->Remove Reporting Services->Add/Remove Programs->Change->Install Reporting Services Cycle.....

Answer 2

To uninstall: From here:

Go to Add/Remove Programs and click Change. Choose Reporting services and continue. At some point you will have to make the choice to remove SQL server. Verify that in the blue bar above it says "Reporting Services" and continue. It's a little nerve-wracking, but that's the way to do it.

Be sure to backup your encryption key first!
(If you have encrypted content in your database.)
And as noted by @NYSystemsAnalyst in the comments: also backup your ReportServerDB and ReportServerTempDB databases!

Answer 3

Most points are covered in KB 842425, aka "How to move a Reporting Services database from a computer that is running Reporting Services to another computer"

Answer 4

I did some SQL downgrading and ran into issues because of this, and created a blog post to help: http://www.sqlwebpedia.com/content/how-to-move-reporting-services-new-server