Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

4 Answers 4

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
1  
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: http://www.sqlwebpedia.com/content/how-to-move-reporting-services-new-server

share|improve this answer

Your Answer

 
discard

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.