Re: Adding 3 nodes to a cluster

The SQL installer allows you to add the new nodes as allowed hosts after you have joined the new nodes to the cluster. You must use the installer (SQL2000) to apply binaries to the new nodes and set the clustered properties correctly.

Look up "maintaining a failover cluster" in BOL.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP



"AJ" <AJ@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:F722B90A-87D0-4D99-8CAD-88BFFE746FDF@xxxxxxxxxxxxxxxx
Hello,

I'm attempting to add three nodes to a SQL 2000 two node cluster. All three
servers have been added but I cannot failover the sql instances from the
previous two node cluster to any of the new servers. I did notice that there
were SQL services for the old instances missing on the new servers. I've
added those missing registry entries but the fail over always fails when
attempting to bring online the SQL server instance.

Is there a way to manually correct this issue?

.

Relevant Pages

  • Re: Adding 3 nodes to a cluster
    ... So you need to add the nodes to the cluster using the Cluster tool. ... Then extend the existing instance to the new nodes using the installer. ... Senior SQL Infrastructure Consultant ... servers acting as a failover in case one of the servers fails. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Adding 3 nodes to a cluster
    ... First you use the cluster admin tool to add the machines as nodes to the cluster. ... Then you run the SQL installer to install binaries on the newly added nodes and allow the new nodes to host the existing instances. ... >>>I need to add these new servers as seperate instances in the SQL ...
    (microsoft.public.sqlserver.clustering)
  • WIN2K3 SP1, SQL Server / MSDTC Issue
    ... I can get SQL Installed ok and everything works fine until I set ... Setup Network Connections (for internal cluster comms and public network) ... Reboot Servers ...
    (microsoft.public.sqlserver.clustering)
  • RE: New SQL 2005 Cluster Questions
    ... You have only one SQL instance in the cluster. ... So, from what I am seeing is I have no choice but to DC the servers, cluster ... Win2003 Ent and then install SQL 2005 Ent onto this cluster. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Adding 3 nodes to a cluster
    ... I need to add these new servers as seperate instances in the SQL cluster. ...
    (microsoft.public.sqlserver.clustering)