Solved

SQL Server 2005 Domain Change

Posted on 2011-09-27
2
303 Views
Last Modified: 2012-05-12
I have an opportunity to move a MS SQL 2005 database instance running on a Windows 2003 server during an AD domain change.

The sql server is going away and will be replaced with a new one, then domain is going away as well. We could just move the domain on the sql server. Not sure that adds any value?

What is the recommended procedure to move the database? What are the issues?


I am looking for details.

0
Comment
Question by:bdorsey63
2 Comments
 
LVL 4

Accepted Solution

by:
rbride earned 500 total points
ID: 36715045
Assuming you have installed the new instance on the new server, you can transfer the user databases simply enough with detach / attach.

The main problem is to transfer the logins. These are stored separately in the master database.
Here is an article with some scripts that show you how to do that:
http://support.microsoft.com/kb/918992/en-us

If you have anything such as linked servers, replication etc, then you will also need to set that up too. Just script them out using the management studio and apply the scripts to the other end.

It is possible to actually move the whole lot, but it is a fair bit more complicated and you need to know how to recover from various errors that can arise when something is not referenced properly.
(See also: http://msdn.microsoft.com/en-us/library/ms345408(v=SQL.90).aspx)
0
 

Author Closing Comment

by:bdorsey63
ID: 36719896
Thanks
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

776 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