Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
add comment

2 Answers 2

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
add comment

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
1  
@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
add comment

Your Answer

 
discard

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.