Thinking to install a SQL instance on your Domain Controller ? Think twice, as it got bad implication if you do.
I will quote the Microsoft’s article: (there )
You cannot run SQL Server services on a domain controller under a local service account.
That mean that you will have to create an Active Directory account to run the service with higher right than a local service account.
After SQL Server is installed on a computer, you cannot change the computer from a domain member to a domain controller. You must uninstall SQL Server before you change the host computer to a domain controller.
After SQL Server is installed on a computer, you cannot change the computer from a domain controller to a domain member. You must uninstall SQL Server before you change the host computer to a domain member.
Plan it right, don’t plan to add an ADDS’s server on your SQL’s server, as you will end up to create another server in the end. Planning it right to prevent unplanned cost to your customer.
SQL Server failover cluster instances are not supported where cluster nodes are domain controllers.
SQL Server Setup cannot create security groups or provision SQL Server service accounts on a read-only domain controller. In this scenario, Setup will fail.
Now we fall into the limitation.
As you can see you are winner to plan your deployment correctly 🙂
ps. there it’s another reference there that show that it’s not something new.