This article was previously published under Q319601
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 356856 (SHILOH_BUGS)
When you run the SQL Server Setup program, and you remove one of the nodes from the Configured Nodes list, and you then run Setup again to add the removed node back to Configured Nodes list, you may see (in Cluster Administrator) that all the SQL Server Resources except the Disk resource have only the first node displayed as a possible owner. This behavior can occur in both SQL Server 2000 Service Pack 1 (SP1) and SQL Server 2000 Service Pack 2 (SP2).
To work around this problem, apply the respective SQL Server service pack (SQL Server 2000 SP1 or SQL Server 2000 SP2) after you add the node back to the Configured Nodes list.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
If you do not use the workaround, the group that hosts the SQL Server resources does not fail over.
For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
295589 BUG: Correcting Mismatched Binaries on SQL Clustered Virtual Server