Moving SQL Server to a new domain

All,
I have the task of separating our AD into 2 domains due to selling one of
our companies off. Unfortunately, one of the SQL 2000 servers belongs to this
company and that needs to be moved to the new domain.
The machine in question is a windows 2003 server running SQL server 2000
sp3a. There are 3 databases on the machine, and there are domain accounts
that have permission to 2 of them.
The project will include creating the new domain and creating a trust
between them so that I can migrate user accounts with SID history, for
Exchange reasons.
How would I be able to move the server to the new domain? Do I just use the
Active Directory Migration Tool to move the server to the domain after the
user accounts have been moved, then assign the new domain user accounts to
the databases?
Any help would be appreciated
Thanks
Andoni"Andoni" <Andoni@.discussions.microsoft.com> wrote in message
news:D3F1B0F8-53BA-43DB-8EB3-6A1E5C40AE33@.microsoft.com...
> How would I be able to move the server to the new domain? Do I just use
> the
> Active Directory Migration Tool to move the server to the domain after the
> user accounts have been moved, then assign the new domain user accounts to
> the databases?
After you migrate everything with ADMT, bounce the server into the new
domain, reset the service account and I do not believe you need to do
anything with login's based on domain accounts because they are sid based.|||Hi Jason,
I have migrated the server, the user accounts were migrated beforehand. By
reset service account do you mean if SQL runs under a domain account? Also,
In the enterprise manager under security/logins, it's still showing domain
users in the old domain instead of the new one. will i need to create new
domain users?
thanks
A
"jason" wrote:
> "Andoni" <Andoni@.discussions.microsoft.com> wrote in message
> news:D3F1B0F8-53BA-43DB-8EB3-6A1E5C40AE33@.microsoft.com...
> >
> > How would I be able to move the server to the new domain? Do I just use
> > the
> > Active Directory Migration Tool to move the server to the domain after the
> > user accounts have been moved, then assign the new domain user accounts to
> > the databases?
> After you migrate everything with ADMT, bounce the server into the new
> domain, reset the service account and I do not believe you need to do
> anything with login's based on domain accounts because they are sid based.
>