I have the following architecture, it consists in only 2 servers, connected to a NAS.
![architecture] : http://ask.sqlservercentral.com//upfiles/arch.gif
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?
asked Dec 19, 2011 at 03:03 AM in Default
For security reasons, Microsoft recommends that you do not install SQL Server 2008 on a domain controller. There are some limitations while installing SQL Server on a domain controller which includes
SQL Server failover cluster instances are not supported where cluster nodes are domain controllers
So, it seems you cannot do it.
Rest of the limitations are
I have never tested this, but one way you may be able to deal with this if you are confined to just two physical servers is to set one of them up to run multiple virtual machines to support both a domain controller and SQL Server under different instances of the OS.
answered Dec 19, 2011 at 08:00 AM