Due to the security recommendation, i will need to uninstall the unused SSRS and SSIS component from a production cluster SQL Server 2008 R2 SP1, so what is the caveats and what do I require to do to ensure the Database engine still up and running ?

Thanks, Al

  • 1
    For what it's worth, a quick way to accomplish this is to merely shutoff the SSRS and SSIS services in the SQL Server Configuration Manager.
    – JHFB
    Jun 27, 2012 at 13:26
  • 1
    Which versions of Windows Server and SQL Server are you using?
    – swasheck
    Jun 27, 2012 at 14:05
  • I want to say that you can do this while everything is online, but I don't know for sure. That said, since you're in a cluster scenario, the worst case would be to fail all instances off one node at a time to do the uninstall, and repeat until it's been removed from all the nodes. Do you have a downtime SLA?
    – Jon Seigel
    Jun 27, 2012 at 16:29
  • I'm using sql server 2008 enterprise r2 sp1 and windows server enterprise 2008 r2 sp1 Jun 27, 2012 at 23:40

1 Answer 1


Neither of these components are cluster aware and they will be separate from the database install, so you would just run the SQL 2008 R2 Add/Remove programs from the control panel of each cluster node and select uninstall for both of these components. A reboot may be required to take effect.

  • Thanks Jason, so in this case I do it for all of my DB instance from the passive node first, fail over and do the active node ? Jun 27, 2012 at 23:41
  • 1
    For the least amount of downtime I think that would be the best plan. Jun 28, 2012 at 4:06
  • 1
    Just blast RS and IS. The cluster could care less.
    – ooutwire
    Jun 28, 2012 at 6:18
  • So did this work for you Albert? Aug 30, 2012 at 20:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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