I have a Windows 2008 R2 server that is a domain controller and also has SQL 2008 installed. I want to remove the AD role and convert this to a standard member server without affecting SQL. There are other DCs in the domain, but currently this server is the only one in this AD site. I will be provisioning a new server and making it a DC before I demote this server.
Will there be any problems with this approach and are there any special considerations I should be aware of?