Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have the following architecture, it consists in only 2 servers, connected to a NAS.

enter image description here

I'm having trouble in implementing clustering because I can't have a domain controller in any of them (if I do the sql server complains...). Is there a way to implement clustering with these limitations?

share|improve this question
up vote 1 down vote accepted

Clustering doesn't support using a NAS.

Current versions of SQL Server don't support using a NAS for storage.

SQL doesn't like being installed on a domain controller.

I don't think that clustering is supported on a domain controller any more.

You'll want to look at database mirroring and having a witness doing automatic failover.

share|improve this answer

Consider using mirroring, not clustering?

MSDN difference overview, a summary:

  • mirroring is per database vs per instance
  • mirroring is 2 instances with own files, clustering is one set of files owned by active node
  • clustering has stricter hardware requirements
share|improve this answer
I'm also considering it, I was just wondering if this is possible or if I'm missing something. Because this would do the automatic failover without a 3rd machine as a witness – RagnaRock Dec 19 '11 at 11:46
@RagnaRock: you can use the free SQL Server Express as the witness which may be useful. But it does get around the DC limitation. Or use a 3rd machine for the DC and witness – gbn Dec 19 '11 at 11:52

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.