Domain Question

Hi,
We are going to configure a 2-node active/passive SQL
server cluster using W2003 Server Enterprise.
A requirement is that both nodes be a member of the same
domain.
We want to make one of these nodes the Primary Domain
Controller. Obviously if you lose that node in the cluster
you will lose the PDC! Can we make the other node a backup
domain controller? So, we can pull the plug on the PDC and
the BDC will now act as domain controller (and SQL server
will failover too)? Will that work
So is it a bad idea in a 2-node cluster to also have the
PDC and BDC be the nodes in the cluster?
Thanks.
We should not configure our cluster nodes as domain controllers; instead, we should use dedicated domain controllers. If we do configure our nodes in any combination of a primary and backup domain controller, it
could have direct implications for any SQL Server environment, as noted in the following Microsoft Knowledge Base articles
298570 BUG: Virtual SQL Server 2000 Installations May Fail if Installed to Windows 2000 Domain Controllers
http://support.microsoft.com/?id=298570
281662 Windows 2000 and Windows Server 2003 Cluster Nodes As Domain Controllers
http://support.microsoft.com/?id=281662
In general, we should NOT install SQL Server 2000 on a domain controller.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx