move SQL 2000 server to new AD domain

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

decipher - 30 Oct 2007 22:20 GMT

Hello,

We have aquired a new company and I need to migrate a SQL 2000 server from
thier existing domain to our AD domain. Other than changing the service
accounts and any SQL domain accounts is there anything else I should be aware
of?

old domain: nt4
new domain: 2000 native
SQL server: win 2k advanced, SQl 2000 std.

thanks!

Reply to this Message

John Bell - 31 Oct 2007 15:38 GMT

Hi

If you are renaming the server as well as moving domain (same name in the
new domain should be ok) you will need to drop the server and re-create it
using sp_dropserver and sp_addserver see
http://support.microsoft.com/kb/303774

If you have windows logins then you will need to migrate those see
http://support.microsoft.com/kb/246133/

John

> Hello,
>
[quoted text clipped - 8 lines]
>
> thanks!

Reply to this Message