I am trying to install an Active/passive cluster of SQL 2000 on a Win2003 machine. Can any one give me details stapes how to configure it same and what are the procedure I have to follow
I can firm windows cluster properly but do I have to install SQL server on all cluster nodes or no need for same. I am little bit confused so please help :

Samee

Step #1: Follow the step by step directions for installing, configuring, and
testing the Windows 2003 cluster
Step #2: Determine what the IP address and name of the SQL Server is going
to be
Step #3: Insert the SQL Server 2000 Enterprise Edition CD into the machine,
follow the prompts on the screen

No, that isn't being a smart ass. Those are precisely the steps you need to
go through.

--
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com

Just to flesh out Michael's explanation...

Comments Inline

"Michael Hotek" <mhotek (AT) nomail (DOT) com> wrote


address, and a unique network name. If you want more than one disk, you can
add it to the virtual server later.

resource for the SQL clustered instance. Active-passive is really just a
single clustered instance. Unlike the old SQL 7.0 clustering, each node is
a true peer. The only difference comes when installing or updating. You
need to be aware of which node hosts the SQL instance for the update to do
what you expect
One more quick note. SQL works with local binaries and shared data.
Binaries are installed on all nodes during the install process. Same for
service packs. There are special procedures for adding and removing cluster
host nodes, but they are well documented in BOL. Read everything under the
topic 'Failover Clustering'.

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

Thanks friends i have done now my SQL server is up and running with cluster
.....

Thanks a lot ...


"Sameer Prabhune" <sameer_prabhune (AT) hotmail (DOT) com> wrote

what are the procedure I have to follow?
help