Domain Setup with 2 servers - 2003 Std & 2008 Std plus SQL2008

Posted on 2009-04-25
Last Modified: 2012-05-06
I have 2 servers that need to go on the same network with some software that requires a domain setup.  I have a Windows 2003 Std just setup as a file server in workgroup mode.  I have a new Windows 2008 Std server that needs to run SQL 2008.  I heard you shouldn't make the SQL server a DC?  So, what's the procedure to convert the 2003 server to the DC and then make the 2008 server part of the domain?  I have XP Pro workstations that need to authenticate to both servers.  I originally posted this but just found out that SQL shouldn't be on the DC.  Looking for the easiest procedure to setup as we don't need anything complicated.  Thanks!
Question by:randyphillips
    LVL 95

    Accepted Solution

    If you have NO custom set file permissions in the existing 2003 server, then this should be relatively painless.  Follow the directions here:

    Then you join the 2008 and XP systems to the domain - see:
    (Don't have a link for joining 2008, but I believe it's still under the System control panel and the procedure is very similar to XP.

    BEFORE DOING THIS - do a system state backup on the XP and 2003 servers - see - on the 2008 server, you'll need to do a complete backup of the C: drive.

    I almost always recommend STARTING with a domain and never using a workgroup because, among other thing, migrating to a domain from a workgroup can be problematic if you've customized anything at all in the workgroup.

    As for using Active Directory Authentication with SQL, can't help you on that.

    Author Comment

    Makes perfect sense.  I will consider the "starting with a domain" in the future.  We just thought keeping things simple was best.  Have never had a problem or rarely a need to have a DC other than SBS forcing that.

    When doing the DC install on the 2003 server do we have to enable DNS?  No reason to do that as the router does that for us - correct?  Or, should we just let it do DNS?  Confused.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
    Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
    This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
    This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

    728 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

    23 Experts available now in Live!

    Get 1:1 Help Now