This post is more than 5 years old
2 Intern
•
199 Posts
0
587
May 9th, 2012 21:00
SQL 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.
No Events found!
RafaelNovo
92 Posts
0
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.
Jingyi1
2 Intern
•
199 Posts
0
May 13th, 2012 18:00
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.