Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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

share|improve this question
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 '12 at 13:26
1  
Which versions of Windows Server and SQL Server are you using? –  swasheck Jun 27 '12 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 '12 at 16:29
    
I'm using sql server 2008 enterprise r2 sp1 and windows server enterprise 2008 r2 sp1 –  Server System Specialist Jun 27 '12 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.

share|improve this answer
    
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 ? –  Server System Specialist Jun 27 '12 at 23:41
1  
For the least amount of downtime I think that would be the best plan. –  Jason Cumberland Jun 28 '12 at 4:06
1  
Just blast RS and IS. The cluster could care less. –  ooutwire Jun 28 '12 at 6:18
    
So did this work for you Albert? –  Jason Cumberland Aug 30 '12 at 20:54

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.