move SQL 2000 server to new AD domain

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!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
"decipher" wrote:
> 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!