SQL 2000 Cluster - Node failed now SQL won't reinstall
Posted on 2009-05-14
This is an issue that happened long before I joined the team and now I get to try and fix the problem:
We have a two node cluster. One of the nodes hardware failed and had to be rebuilt two years ago. We are unable to use true clustering because the cluster will not fail back over to the node that had previously failed. We are unable to get SQL installed on the previously failed node. The error message states "Setup failed to perform required operations on the cluster nodes."
I have tried reading the sqlstp.log files but they don't make much sense to me at this point.
Yesterday I evicted the previously failed node, uninstalled cluster services and then reinstalled cluster services to join the failed node back into the cluster.
We really need to get this node functioning properly again, in case something happens to the node that's been working fine for the past couple years.
Thanks for everyone's help.