Demoting a SQL 2000 server that is also a Domain Controller
In a domain a client has several Domain Controllers. One of them is also a SQL server (I know this isn't reocmmended, it was already like that). That server now needs to be demoted. The only ramification I can think of pertains to how the services are configured. As long as all services aren't running as local accounts on the server when it's demoted is anyone aware of other complications that I'm not taking into account? Also, after the demotion people will need to continue to access this machine until I can schedule a restart....is anyone aware of complications not restarting immediately?