Is this true that Active Directory is needed in order to cluster the SQL2000.

I have 2 Dell 6000 series with a shared Dell RAID....

Any articles or links to see how can I set this up correctly?

You need a domain, NT 4.0, 2000 or 2003. AD is not needed.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering

"Eugene Borukhovich" <macroscape (AT) yahoo (DOT) com> wrote

So w/o actually reading through all the links yet and to confirm that
there is no dependencies on the AD at all. When you say "domain" - can
it be a workgroup?

this will be in a highly secure environment, so i dont want any AD nor
these SQL servers even joining the AD.

Thanks, Eugene B

You can't have it on a workgroup. It must be on a domain - AD or NT. If
you really want security, then you'll have to put it within its own forest
and set up a one-way trust.

--
Tom

---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql


"Eugene Borukhovich" <macroscape (AT) yahoo (DOT) com> wrote

So w/o actually reading through all the links yet and to confirm that
there is no dependencies on the AD at all. When you say "domain" - can
it be a workgroup?

this will be in a highly secure environment, so i dont want any AD nor
these SQL servers even joining the AD.

Thanks, Eugene B

Clustered SQL Servers must have a common security context. This means they
must be member servers of an NT4 or AD domain. A common workgroup will not
work.

I am concerned that you see AD as a security problem rather than a solution.
Perhaps your system administrators do not fully understand how to implement
AD in a highly secure environment.

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

I support the Professional Association for SQL Server
www.sqlpass.org

"Eugene Borukhovich" <macroscape (AT) yahoo (DOT) com> wrote

Hi ,
I am trying to install cluster SQL2000 on a WIN2003MSCS. Are there any
links to step by step procedure. Install on a WIN 2000 is quite
different.WIN 2003 cluster service is setup and running. Any
documentations on a SQL virtual server setup will be much appreciated.
Thank you

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!