I have a 2 Node SQL 2000 Cluster using Dell Servers and a SAN. I would like
to add two HP Servers to the Cluster and then eventually fail over to them

Is the different hardware going to be an issue?


Do I need to install SQL 2000 on the servers prior to joining them to the
Cluster or by Adding them to the Cluster will they automatically have SQL and
the appropriate Service Packs Pushed down to them?

You should have no problem as long as the new servers are certified with the
existing SAN. Basically, you'll add the nodes to the cluster, using Cluster
Admin. Next, you'll use the SQL 2000 install media to add the binaries to
the new nodes. Next, you'll add the appropriate SQL 2000 service pack, and
then any hotfixes. After testing failover, you then evict the old nodes
from the cluster.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


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

I have a 2 Node SQL 2000 Cluster using Dell Servers and a SAN. I would like
to add two HP Servers to the Cluster and then eventually fail over to them

Is the different hardware going to be an issue?


Do I need to install SQL 2000 on the servers prior to joining them to the
Cluster or by Adding them to the Cluster will they automatically have SQL
and
the appropriate Service Packs Pushed down to them?

Asymmetrical clusters are not supported prior to Windows 2008. They also
are a real pain and are often unstable prior to Windows 2008.


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



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

How do I go about adding the Binaries? Do I just do a normal install of SQL
or once I add the node to cluster and put the SQL Disk in the install will
know?

"Tom Moreau" wrote:

Read the section in BOL on "Maintaining a Failover Cluster". It will walk
you through the installer steps.

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


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

I now have both new visible in the cluster with SQL installed. The only thing
I was unable to do is run the SP4. It gave us an error message: “Setup
cannot verify/grant logon as service right to the SQL Server service logon
account: 5000 (0x1388)

Do I need to make this nodes Active and the install SP4?

Marc

"Tom Moreau" wrote:

Try failing over to that node without SP4. That may "set" the account
properly.

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


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