SQL Server 2005 migration to a new domain

Posted on 2012-09-15
Last Modified: 2012-10-02
Hi there,

Our entire office is moving to a new building.  This new building will merge two companies, each currently with their own AD domain.  In order to start fresh, we are implementing a new domain, with new services (Exchange 2010, BES 5.0, Domain Services, etc.).  We currently have a SQL Server 2005 VM that hosts several databases.   We want to migrate this server that hosts SQL Server to the new domain and we're looking for the easiest steps to get this done.  This is a stand alone SQL Server.  The name won't change, we just want to join it to a new domain.  The 2005 server is currently hosted on a Windows 2003 server.

What are the easiest steps we need to do to get this done?  

The SQL server is currently a VM, can we make changes and if it doesn't work, can we restore a backup of the VM?

To note, we will be implementing a new SQL Server 2008 Standard R2 instance and we may migrate the data from the 2005 server to this new 2008 server, but we don't want to do that now.  The SQL Server 2008 instance will be on a Windows 2008 Enterprise R2 VM.  Knowing all of this, would you recommend migrating the data to the new SQL Server 2008 server instead?

Thank you,
Question by:Christian Palacios
    LVL 38

    Expert Comment

    by:Jim P.
    Normally I'd point you to the sp_help_revlogin   to transfer logins.  It might still be helpful to get the Windows and then change the domain and ignore the SID.

    You'll still have to tie the users to the DBs and roles manually.

    Also all user's will have to be recreated from scratch.

    Quite frankly their is no pretty way to do this.
    LVL 77

    Expert Comment

    by:David Johnson, CD, MVP
    would sql replication help? Any Windows Integrated login data will be useless, only SQL logins will be available (if you use them) once you change the domain.
    LVL 20

    Expert Comment

    by:Marten Rune
    Id make sure the SQL runs on a local account before doing any migration.

    Then analyze all windows integrated login, as to role membership, if granted special privilidges, dont forget to look into the MSDB database.

    Now analyze whats running outside of the core database engine?  Log shipping, replication, mirroring, Service Broker, Reporting Services, etc?

    Now plan your move to the new domain.
    i e make the machine leave the old domain, join the new, set up service account/accounts for the SQL. Recreate AD groups/accounts and map them towards the SQL

    The only thing you don't have to worry about is the old SQL accounts.


    Author Comment

    by:Christian Palacios
    Thank you everyone, we'll give it a shot!

    - Christian

    Accepted Solution

    We will not be migrating to a new domain anymore so we won't need this solved.  Thank you for your answers though!

    - Christian

    Author Closing Comment

    by:Christian Palacios
    We will not be migrating to a new domain anymore so we won't need this solved.  

    - Christian

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    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…
    This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…

    761 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

    11 Experts available now in Live!

    Get 1:1 Help Now