Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question
up vote 2 down vote accepted

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.....

share|improve this answer
You are a genius. – Ronnie Overby Jun 12 '09 at 17:18

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!

share|improve this answer
Be sure to backup the ReportServerDB and ReportServerTempDB databases if you need reports, settings, etc. in there. – NYSystemsAnalyst Jun 12 '09 at 13:28

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"

share|improve this answer

I did some SQL downgrading and ran into issues because of this, and created a blog post to help:

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.