SQL 2005 Cluster Install - Unavailable node.

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.
LVL 1
rjayresAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

pmarquardtCommented:
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
rjayresAuthor Commented:
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
pmarquardtCommented:
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
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

rjayresAuthor Commented:
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
pmarquardtCommented:
So, does the cluster service show that it is running on each node?
0
rjayresAuthor Commented:
yes.. groups move properly too.
0
pmarquardtCommented:
Did you try installing SQL on the unavailable node previously?
0
dearvjkumarCommented:
Check the cluster configuration, virtual name or ip is correctly specified. Check the cluster log for more details, able to see quarm disk?
0
rjayresAuthor Commented:
ok.. I figured it out.. remote registry service was off, turn it on.. works fine.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pmarquardtCommented:
Was that in DCOM, or just the standard Remote Registry Service?
0
rjayresAuthor Commented:
just the standard.. was disabled (by one of the RIS scripts that loaded the machines)
0
pmarquardtCommented:
Ok, thanks for the update. I'll add that to my list of fixes. :-)

Glad you got it fixed.
0
modus_operandiCommented:
Closed, 500 points refunded.
modus_operandi
EE Moderator
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.