Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

1 Answer

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

share|improve this answer
add comment

Your Answer

 
discard

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