promoting a dedicated SQL 2005 Standard server to a domain controller

Posted on 2011-10-30
Last Modified: 2012-05-12
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.
Question by:gopher_49
    LVL 7

    Expert Comment

    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.
    LVL 27

    Expert Comment

    by:Jason Watkins
    Make sure the SQL server is using the DC (or domain's DNS server) for it's DNS server

    Author Comment

    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?
    LVL 27

    Expert Comment

    by:Jason Watkins
    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.
    LVL 7

    Accepted Solution

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Scenerio: You have a server running Server 2003 and have applied a retail pack of Terminal Server Licenses.  You want to change servers or your server has crashed and you need to reapply the Terminal Server Licenses. When you enter the 16-digit lic…
    Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL ( several years ago, it seemed like now was a good time to updat…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now