?
Solved

SQL 2005 Cluster Install - Unavailable node.

Posted on 2007-04-10
14
Medium Priority
?
1,225 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 
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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

765 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