I had initial had one server and set up the Windows 2000
server cluster (A) with SQL Server 2000. After several
months I received the other Windows 2000 server (B). I
set up the dependencies on server (A/B) to match the other
Windows 2000 Server Cluster that works fine. When I
trying to fail the Server 3 times to role to the other
node. I received the following error.

Error: A cluster node is not available for the
operation.

Please help me resolve this error.

Thank You,

Dean

Did you actually install SQL on the second node? SQL uses local binaries
and shared data so an install must be performed on each node. There are
instructions in BOL on adding a node to an existing cluster. you will also
need to install any service packs on the new node. Adding a node to SQL can
be done with the existing node online the entire time, including adding the
service pack.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com




"Dean" <anonymous (AT) discussions (DOT) microsoft.com> wrote

That wasn't as clear as it looked the first time.

The normal cluster install will put binaries on all nodes that are available
at the time of the install. The 'ADD NODE' install must be targeted to
specific nodes.

"Geoff N. Hiten" <SRDBA (AT) Careerbuilder (DOT) com> wrote

SQL Server 2000 was installed on the second server without
a problem which asked for the Virtal Server name. I did
not set up the add node for the second server a system
administrator set up the Windows 2000 Advanced Server
Cluster. I configured the settings on the added node to
match a Windows 2000 Advanced Server Cluster that works
fine. Is there away to determine if the second node was
set up properly?

Thank You,

Dean

Sounds like the node was added to the cluster but not SQL. You will need to
re-run the SQL installation and add the node to the allowed SQL hosts.
Adding the node to the cluster is not sufficient. Modifying the cluster
groups by hand is not sufficient. The install must be run in order to
create the binaries on the second node. Follow the instructions in SQL BOL
to add a node to an existing virtual server.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com




<anonymous (AT) discussions (DOT) microsoft.com> wrote