Solved!
Go to SolutionSQL server cross site HA solution needs Domain Controller?
IHAC want to extend their standalone SQL server across sites. The second DataCenter is located in 1KM away and connected with dark fibre. Customer will build SQL server HA with windows 2003 cluster and SQL server 2005. Do we need to add a Domain Controller to provide Active Directory service for SQL Server HA? Can we put the DC and SQL server in the same physical host? Thanks for your inputs.
Thanks Rafa, I did some research and get same conclusion as yours. MSCS is needed to install the SQL Server Failover Clustering and MSCS memeber needs to visit active directory to get identity verified. It's recommened to separate SQL Server Host and DC.
RafaelNovo
92 Posts
116
0
Posted May 12th, 2012 18:00
You will need an AD at second datacenter in a event of total loss of primary datacenter.
This AD server should be - preferentially - a dedicated server.