Monday, March 19, 2012

applying SP to 2005 active/active cluster

I have a 2005 active/active cluster and want to apply SQL server 2005 SP2 to both node.
I know that for active/passive , the sp can simple be installed on the active node(instance) and everything will be replicated to the other node.
bear in mind what I have SSIS and SSAS and SSRS running on the active/active cluster.

what is the rigth method for applying the SP to active\active cluster?

Thanks

We had the same situation a couple of weeks ago. When had several problems applying SP2 to the clustered machines. After talking to MS for several hrs about our problems, we finally corrected it....it was issues with different settings on our cluster. However, MS did recommend having both instances on one server, the primary, when you do the upgrade. I can't remember if the SP was applied to both nodes though. If it is not, its no big deal. Just apply it to the second node. I hope you have better luck than we did.

PS. Make sure that DCOM is enabled on both servers.

No comments:

Post a Comment