adding second node to sql cluster

I created a one node Cluster in Windows 2003 enterprise server. I then loaded
a SQL 2000 Vitrual server. I now need to add a second node. The cluster sees
the new node. However when I attempt to load the SLQ executables on the
second node the only option I have once I choose the virtual server is to
upgrade the existing installation. That does not install the executable on
the second node. What am I doing wrong. Thanks in advance.
you must choose upgrade the existing installation on virual server and add
second node for existing virtual sql server
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Joe McHae" wrote:

> I created a one node Cluster in Windows 2003 enterprise server. I then loaded
> a SQL 2000 Vitrual server. I now need to add a second node. The cluster sees
> the new node. However when I attempt to load the SLQ executables on the
> second node the only option I have once I choose the virtual server is to
> upgrade the existing installation. That does not install the executable on
> the second node. What am I doing wrong. Thanks in advance.
|||I did choose upgrade. I did not see an option to add a second node for the
existing sql server. The second server is in the cluster.
"Aleksandar Grbic" wrote:
[vbcol=seagreen]
> you must choose upgrade the existing installation on virual server and add
> second node for existing virtual sql server
> --
> Aleksandar Grbic
> MCDBA, Senior Database Administrator
>
> "Joe McHae" wrote:
|||In the setup routine, there will be an Advanced option. After selecting,
there will be a Maintain and Existing Installation option.
This will take you down an installation path were you can add new cluster
member nodes as a potential SQL Server failover partner.
In the maintenance section of the SQL Server 2000 failover clustering
document is an Add/Remove Cluster Nodes sub-section.
Adding or Removing a Cluster Node from the Virtual Server Definition
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx#EPUAG
Best of luck.
Sincerely,
Anthony Thomas

"Joe McHae" <JoeMcHae@.discussions.microsoft.com> wrote in message
news:332E6DA7-9F20-455C-97BE-ABD7BE8EFAE8@.microsoft.com...[vbcol=seagreen]
> I did choose upgrade. I did not see an option to add a second node for the
> existing sql server. The second server is in the cluster.
> "Aleksandar Grbic" wrote:
add[vbcol=seagreen]
loaded[vbcol=seagreen]
cluster sees[vbcol=seagreen]
the[vbcol=seagreen]
to[vbcol=seagreen]
executable on[vbcol=seagreen]
|||Anthony;
thanks, the problem I wa having was the executables for SQL were not loading
on the second node. I followed your link then removed the node and added it
again. for some reasons the executables are there. I guess that is why they
call it magic.
Joe
"Anthony Thomas" wrote:

> In the setup routine, there will be an Advanced option. After selecting,
> there will be a Maintain and Existing Installation option.
> This will take you down an installation path were you can add new cluster
> member nodes as a potential SQL Server failover partner.
> In the maintenance section of the SQL Server 2000 failover clustering
> document is an Add/Remove Cluster Nodes sub-section.
> Adding or Removing a Cluster Node from the Virtual Server Definition
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx#EPUAG
> Best of luck.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Joe McHae" <JoeMcHae@.discussions.microsoft.com> wrote in message
> news:332E6DA7-9F20-455C-97BE-ABD7BE8EFAE8@.microsoft.com...
> add
> loaded
> cluster sees
> the
> to
> executable on
>
>