SQL Server 2005 migration to a new domain

Posted on 2012-09-15
Medium Priority
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.
ID: 38402703
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 85

Expert Comment

by:David Johnson, CD, MVP
ID: 38402741
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: 38403596
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.

Free tool for managing users' photos in Office 365

Easily upload multiple users’ photos to Office 365. Manage them with an intuitive GUI and use handy built-in cropping and resizing options. Link photos with users based on Azure AD attributes. Free tool!


Author Comment

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

- Christian

Accepted Solution

Christian Palacios earned 0 total points
ID: 38442923
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
ID: 38453837
We will not be migrating to a new domain anymore so we won't need this solved.  

- Christian

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Active Directory can easily get cluttered with unused service, user and computer accounts. In this article, I will show you the way I like to implement ADCleanup..
It’s time for spooky stories and consuming way too much sugar, including the many treats we’ve whipped for you in the world of tech. Check it out!
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Suggested Courses

593 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