Networks·41,398 discussions

Moving SQL Server 2000 from one domain to another

Locked

I have been asked what it would take to move a production SQL Server 2000 from one domain to another. I’m a junior network admin and out DBA just left the company. I have no idea how to do this or what’s involved. Could someone point me in the right direction?

Topic

Clarifications

In reply to Moving SQL Server 2000 from one domain to another

Clarifications

Nice landmine they left you.

In reply to Moving SQL Server 2000 from one domain to another

Ok, moving it isn’t that bad. As long as you’re at least a little comfortable with SQL you might be able to do this yourself.

The problem is how the applications address the SQL server. If there are users in the different databases that are domain specific you will have program issues. If there are machines on the same domain that the SQL server is currently on and you move it to another domain you will break their access.

All of this can be worked around and\or repaired. It will just require some time and patience.

Here is the real question. How critical is the application that uses this SQL server? If it’s a hyper-critical app I would suggest to the bosses that they get you some outside contract help to get it all done. There is never any shame in asking for help if you’re concerned your skill set is a bit short. The problems arise when you tell the boss that it’s no problem and then break the whole process for days. Make sure that they are aware of your concerns and paint them a dooms day picture if you like. You can also tell them that you will be able to gather all sorts of info from the consultant while he’s there making you look good later. 😉

If you’re still ready to move on yourself just make sure that the SQL server and Agent services are not set to a domain account. Verify that you have the SA pasword. You may need this later if there are problems. then fire away change domains. After that you puit on the fireman’s helmet and put out any fires that started with the change.

1 thing to remember, and I’m sure you already know this, is to make sure you have a backup of the system taken just before you start this process.

Best of luck.

[Author]

Replies