If the SQL Server cluster resource is in an "online pending" state and the cluster service sends a termination request to the resource, the resource may not successfully come online again on the node until the cluster service is restarted.
The cluster service usually sends a termination request to a resource to perform a failover.
When the cluster resource DLL terminates a resource that is in the "online pending" state, it does not communicate this information to the cluster service correctly. This puts the cluster service in an unknown state and prevents this resource from coming back online.
To resolve this problem, obtain the latest service pack for SQL Server 2000. For additional information, click the following article number to view the article in the
Microsoft Knowledge Base:
INF: How to Obtain the Latest SQL Server 2000 Service Pack
Restart the cluster service on the node.
Microsoft has confirmed that this is a problem in SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.