Windows 2003 SQL cluster in a Workgroup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

James Matthews - 22 Nov 2006 11:15 GMT

Hi I wish to install a windows 2003 SQL cluster into an environment that does
not have a domain.

Is it possible to configure a cluster without a domain? I know that windows
authetication will not be available on the SQL server but the applications
that we need only use SQL logons.

Any advice?

Reply to this Message

Tom Moreau - 22 Nov 2006 12:01 GMT

A cluster must be part of a domain. See if you can find an inexpensive
server to be a domain controller and use it. That said, if you have a
domain, then you want to have >1 DC's just in case one fails. A cluster is
for high availability. Having >1 DC is also high availability.

Signature

Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.

Hi I wish to install a windows 2003 SQL cluster into an environment that
does
not have a domain.

Is it possible to configure a cluster without a domain? I know that windows
authetication will not be available on the SQL server but the applications
that we need only use SQL logons.

Any advice?

Reply to this Message

Russ Kaufmann [MVP] - 22 Nov 2006 16:08 GMT

>A cluster must be part of a domain. See if you can find an inexpensive
> server to be a domain controller and use it. That said, if you have a
> domain, then you want to have >1 DC's just in case one fails. A cluster
> is
> for high availability. Having >1 DC is also high availability.

I hate to recommend it, but in some cases, like this one, it is pretty cost
effective to use a couple of desktops to be your domain controllers.

Signature

Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

Reply to this Message