Hi,

In a 2-node SQL Server 2000 Active/Passive cluster running
under Windows 2003 Enterprise, can both computers be
member if a workgroup (i.e. "WORKGROUP") or do they "have"
to be members of a domain?

Thanks.

They must be members of the same DOMAIN.
A 'workgroup' will not support a clustered environment
because permisssions, rights, service accounts must
maintain their account privledges during a failover to the
other node.

They HAVE to be domain members. The cluster service requires a common
security context to transfer resources and manage virtual servers.

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

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

<anonymous (AT) discussions (DOT) microsoft.com> wrote