Cluster 2005 need help please

quick overview

2 nodes-cluster setup from node 1

I setup a cluster, created 4 groups

1.cluster 2.msdtc 3.sqlinstance1 4.sqlinstance2

I want to create an active\passive on both nodes. (onenode will be the active node for on sql install while the other is passive.

I want to repeat this fo rthe second node, the second node being active and node 1 passive.

I logged into node 1 and I installed sql 2005 in failover cluster into sqlinstance 1., everyhting was fine, failover etc.

Now I logged into node 2 and ran sql 2005 setup to create a failover cluster.

I chose to install into sql instance 2.

Database unable to install with error "failed to set registry settings for server network libraries. acition is setdefaults.error 11001, no such host is known.

If I am not setting this up correclty please let me know

thanks

everything was fine. I logged onto node 2, was going to

Which node owns the disk resources that you are trying to install to? You can very simply run the setup routine twice from the same node. Then when you are done with both installs, all you have to do is move the group for one of the instances to the other node and you are done with your configuration. The node that you install from is irrelevant to where you want the instances to run.|||

Hi,

I don't know specifically the answer to your question, but here is a white paper that you might find useful:

SQL Server 2005 Failover Clustering
http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en

|||

the architect wants sql installed on both nodes. All groups and reasources are owned by node 2, just not the first install of sql which is still owned by node 1.

thanks

|||

Hi,

This issue happens due to a orphan registry key.

Delete the followinh key from both nodes:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\Cluster

Be carefull while deleting the key, as quorum checkpointnig could cause issues.

HTH