Solved

SQL 2005 Cluster Install - Unavailable node.

Posted on 2007-04-10
14
1,217 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
 
LVL 1

Author Comment

by:rjayres
Comment Utility
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
Comment Utility
So, does the cluster service show that it is running on each node?
0
 
LVL 1

Author Comment

by:rjayres
Comment Utility
yes.. groups move properly too.
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 4

Expert Comment

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

Expert Comment

by:dearvjkumar
Comment Utility
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
Comment Utility
ok.. I figured it out.. remote registry service was off, turn it on.. works fine.
0
 
LVL 4

Expert Comment

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

Author Comment

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

Expert Comment

by:pmarquardt
Comment Utility
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
Comment Utility
Closed, 500 points refunded.
modus_operandi
EE Moderator
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

728 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

9 Experts available now in Live!

Get 1:1 Help Now