Solved

SQL 2005 Cluster Install - Unavailable node.

Posted on 2007-04-10
14
1,221 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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sql Data via Excel--performance issues 2 56
MS SQL page split per second is high 19 104
ms sql + top 1 for each customer 3 56
Analysis of table use 7 54
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…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

860 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