the cluster resource cannot be moved to another group because other resources are dependent on it

When upgrading from sql 2000 enterprise to sql 2005 enterprise and installing the sql server database services on a cluster service I get an error.  It occurs during the "removing backup files" phase of installing the database services.   The error I get is "  Microsoft SQL Server 2005 Setup - The setup has encountered an unexpected error while Completing Commit.  The error is The cluster resource cannot be moved to another group because other resources are dependent on it"  

I am not sure what needs to occur here in order for the sql cluster to be updated successfully.  Are there some dependencies I need to take offline?  Any help would be appreciated.  Attached is the error message
cluster-error.doc
v4seasonsAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
Could you tell me the cofiguration setting of your Cluster Administrator.
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
You might be having some SQL resource dependent on some other resource is that up ?
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
SolarWinds® IP Control Bundle (IPCB)

Combines SolarWinds IP Address Manager and User Device Tracker to help detect IP conflicts, quickly identify affected systems, and help your team take near instantaneous action. Help improve visibility and enhance reliability with SolarWinds IP Control Bundle.

v4seasonsAuthor Commented:
I am upgrading to sql 2005.  Are there instructions on how to install the database services for sql 2005?  Attached is a screenshot of my current configuration.  Do I need to shut down the node that is not currently active and install the database services on the active node?  Please advise.
cluster-configuration.doc
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
Does any of the resources in DIsk1 for SQL have connection to Cluster Group resources.
v4seasonsAuthor Commented:
No I don't think so.  Here is a screen shot of disk group1 and the cluster group.
cluster-configuration-2.doc
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
Try creating a MSDTC for Cluster and also did you verify if the SQL has been upgraded or not ?
v4seasonsAuthor Commented:
It has not been upgraded.  It is still on version 8.0.  It rolls back and never completes the installation.  Looks like I already have a MSDTC connection created.  It will not allow me to create another one.
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
You have created the MSDTC in SQL ideally its in Cluster group try that once.
v4seasonsAuthor Commented:
I am not sure what you are asking me to do.  I tried to create a MSDTC as a new resource in the cluster group and I get the following attached error:

Please advise.
MSDTC-error.doc
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
You have a resource in SQLDTC try removing that and then creating a MSDTC in cluster grooup and try to upgrade.
Did you try moving the resources to other node andd try the upgrade ?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
Hello V4 any updates on the SQL upgrade issue ?
v4seasonsAuthor Commented:
Modifying the dependencies of the SQLDTC I removed them during the upgrade and added them back.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.