I have 3 servers 1 production 1 standby and 1 just sitting there.
I want 1 to stay production and I have been working on setting up an MSSQL automatic failover cluster between the production server and the standby server. I require a witness server and an active directory.
My question is: Can I install the MSSQL witness server on a Domain Controller? If not, WHY?
This would allow me to NOT virtualize or purchase a fourth machine. Has anyone done this in a production environment?