SQL Server x Domain Controller
-
In general, it's not even Microsoft supported to install SQL server on a Domain Controller at all.
Your supported options are:
- If the domain controller is a physical machine, convert it to a Hyper-V host with a Domain Controller guest and use the second Hyper-V VM license entitlement for the SQL server (Standard lets you have 2 VMs per set of Standard licenses for a physical box)
- See 1.
Otherwise, you MUST use a domain account for all service accounts and those account(s) MUST be domain administrators (SQL setup will take care of that automatically), as only domain administrators can log onto a domain controller in any fashion. Obviously, this is the reason why SQL x DC is unsupported, as it's a very very bad security posture.
-
See, and here I was thinking there was a secret sauce on how to get it running properly with a normal local account...
-
What I did instead was group-policy that account to be allowed local login, and removed it from the domain admins group after the install completed. Seems to be working fine.
-
-
