Change SQL Server 2000 from Active/Active to Active/Passive
You can review this MSSQLTip to get more information on what active/active and active/passive mean in regards to SQL Server Clusters:
SQL Server Clustering Active vs Passive

In your situation, and based on your comments, the only thing you need to do is configure the dependencies for your resources. So if I have a cluster resource for the the SQL Server Cluster Name and it fails over, then all of the dependent resources will follow suite. 

I have not messed with or ever configured a SQL Server 2000 cluster so I do not know what how this was done during installation. I am aware that starting with SQL Server 2005 the installation did more of this for you: Failover cluster resource dependencies in SQL Server