Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We have SQL server 2005 running on our cluster with Service Pack 2.

However one of the nodes failed, after rebuilding the node I added the node back to the clster with SQL server setup. However it gave me a warning that the version being installed (without service pack) was different the the version running (SP2).

I continued anyway assuming I could install the service pack after the node was added (as recommended in the warning message).

So now the node has been added I run the SP2 setup on the rebuilt node, however the installation will not update the MSSQLSERVER\Database Services part. It tels me it can only update on the active node.

How do I get this node into a state capable of fail over?

Many Thanks, Ady

share|improve this question

Apply Service Pack 2 to the Active Node again and it will update both nodes of the cluster.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.