Solved

SQL 2005 Cluster Install - Unavailable node.

Posted on 2007-04-10
14
1,220 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
14 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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

813 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now