?
Solved

SQL 2005 Cluster Install - Unavailable node.

Posted on 2007-04-10
14
Medium Priority
?
1,229 Views
Last Modified: 2008-01-13
I'm trying to install SQL 2005 on a two node shared storage cluster in active/passive mode, When I get to the Cluster Node Configuration dialog box the other node in the cluster shows in the Unavailable nodes, gives the server name and the reason as unknown.
0
Comment
Question by:rjayres
13 Comments
 
LVL 4

Expert Comment

by:pmarquardt
ID: 18889014
Are there two nodes already configured in the cluster? Or, are you trying to set up the two nodes into a cluster? What type of drive (local and shared) do you have, i.e. SCSI, iSCSI, Fibre Channel, etc... Also, how do you have the hearbeat NICs configured on the nodes? Have you looked at C:\%systemroot%\cluster\cluster.log file to see what errors you are receiving?
0
 
LVL 1

Author Comment

by:rjayres
ID: 18889256
Two nodes are already in a cluster, local drives are SCSI, Shared Storage is Fiber Channel, heartbeat NICs configured in their own subnet, set for cluster traffic only, other NICs are set for application use only... I will look in the log file soon as I get to work.
0
 
LVL 4

Expert Comment

by:pmarquardt
ID: 18889629
I need you to verify the heartbeat NICs are set to use only TCP/IP.

Turn off Client for Microsoft Networks
Turn off File and Print Sharing
Disable Netbios
Disable DNS
Verify no Default Gateway exists on the heartbeat NICs

Let me know what you see in the cluster log, and see if you find an error in the Event Viewer under the System log correlating to the node failure.

0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Author Comment

by:rjayres
ID: 18890627
Ok.. set the Hearbeat NICs up as you suggested, rebooted, SQL install still says the other Node is Unavailable - Unknown.

Nothing in either event log to indicate any issues of any kind, I can even see the unavailable node being send a start control from the node that I am attempting to load SQL from.
0
 
LVL 4

Expert Comment

by:pmarquardt
ID: 18901361
So, does the cluster service show that it is running on each node?
0
 
LVL 1

Author Comment

by:rjayres
ID: 18901467
yes.. groups move properly too.
0
 
LVL 4

Expert Comment

by:pmarquardt
ID: 18901478
Did you try installing SQL on the unavailable node previously?
0
 
LVL 2

Expert Comment

by:dearvjkumar
ID: 18932566
Check the cluster configuration, virtual name or ip is correctly specified. Check the cluster log for more details, able to see quarm disk?
0
 
LVL 1

Accepted Solution

by:
rjayres earned 0 total points
ID: 18932595
ok.. I figured it out.. remote registry service was off, turn it on.. works fine.
0
 
LVL 4

Expert Comment

by:pmarquardt
ID: 18934245
Was that in DCOM, or just the standard Remote Registry Service?
0
 
LVL 1

Author Comment

by:rjayres
ID: 18934513
just the standard.. was disabled (by one of the RIS scripts that loaded the machines)
0
 
LVL 4

Expert Comment

by:pmarquardt
ID: 18934525
Ok, thanks for the update. I'll add that to my list of fixes. :-)

Glad you got it fixed.
0
 
LVL 1

Expert Comment

by:modus_operandi
ID: 20648856
Closed, 500 points refunded.
modus_operandi
EE Moderator
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question