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

[quoted text, click to view]
Sounds like you have gotten this far. Enough said.

[quoted text, click to view]
Each SQL instance will need at least one physical disk resource, a unique IP
address, and a unique network name. If you want more than one disk, you can
add it to the virtual server later.

[quoted text, click to view]
Make sure the machine is the one currently hosting the physical disk
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
[quoted text, click to view]

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'.

[quoted text, click to view]

--
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 ... :)


[quoted text, click to view]
machine. Can any one give me details stapes how to configure it same and
what are the procedure I have to follow?
[quoted text, click to view]
on all cluster nodes or no need for same. I am little bit confused so please
help :(
[quoted text, click to view]