promoting a dedicated SQL 2005 Standard server to a domain controller

I have a Windows 2003 Standard server that also has SQL installed on it.  I'm using it for a file/SQL server for 15 users.  I have another server that is a domain controller.  It is dedicated for a domain controller.  I want to promote my SQL server to a domain controller also.  The reason for this is to have multiple DC's and we're limited on backup licenses for our DR site and limited on storage.  So...  I want to save a license/storage and simply make one of the servers already being replicated a domain controller.  Is this okay?  I thought using a SQL server as a DC was not recommended.. But...  In an envorinment this small I didn't think it would matter too much.
Who is Participating?
MrAliConnect With a Mentor Commented:
Since your computer was already a member of the domain, you should be pretty good already with permission issues and such.  It's not recommended practice but yes, it will work.  I've seen SQL ran on domain controllers before numerous times.
Having SQL Server do both isn't recommended, and there are nuances with clustering as well, you do not cluster DCs so keep that in mind if you are in fact, utilizing clustering.  If the current server is already a member of the domain, just not a DC, then you just need to run DCPROMO from a dos (command) prompt.  If it isn't, then you have a bunch of permission issues we need to resolve first.  Let us know if it isn't.
Jason WatkinsIT Project LeaderCommented:
Make sure the SQL server is using the DC (or domain's DNS server) for it's DNS server
gopher_49Author Commented:
The SQL server is a member server and already using the correct dns server, however, I don't want to cause any issues in the future.  I do not use clustering nor do I plan to.  Is this a safe config?
Jason WatkinsIT Project LeaderCommented:
Will the SQL component still be needed after the server has been promoted? File system security and GPO setting change to a server after it has been promoted. Any local account that may exist on the server will no longer be available after promotion.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.