• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3006
  • Last Modified:

Installing sql server 2005 sp3 on a cluster

We are about to install  sql server 2005 sp3 on a cluster. The cluster is active passive node with SSRS installed in both the nodes.
My question is what impact its got on the SSRS when we install on the nodes.?Also do we need  to have downtime?

Note: We see  SSRS active on both nodes  at times even though one of them being passive.
0
venk_r
Asked:
venk_r
1 Solution
 
Marten RuneCommented:
The SSRS is not cluster aware. That is why you see them active on both nodes. It's by design.

Now to the real question. Is it a upgrade to SP3 for your both nodes?
If so, run the SP3 on the active node, You will need to failover and restart both nodes when done. SP should be installed once per instance. Logical when you need a scenario with different SP on the same cluster.

Yes it will require downtime. In your case I would suggest that it's done under a maintenance time window, and that you test the clusters failover function after the upgrade.

If you want to install another instance with sp3, then thats another question. Please reply and I will answer.
/Marten
0
 
gaddam01Commented:
please specify me the hardware requirements for installing sql 2005 Database server  in failover cluster mode??
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now