BUG: The second cluster node is not listed as a possible owner in Cluster Administrator

Article translations Article translations
Article ID: 319601
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)
Expand all | Collapse all

On This Page

Symptoms

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).

Workaround

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.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

More information

If you do not use the workaround, the group that hosts the SQL Server resources does not fail over.

REFERENCES

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

Properties

Article ID: 319601 - Last Review: November 2, 2013 - Revision: 4.0
Keywords: 
kbnosurvey kbarchive kbbug kbpending KB319601

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com