SQL Server Domain Migration

We will be migrating several SQL servers (non-clustered) to a new
Active Directory domain in a seperate forest. We plan on using the
ADMT to migrate the computer and user accounts. Other than adjusting
the startup accounts on the SQL services, is there anything else I
need to be aware of?

I did find some KB articles and other posts, but they mostly talk
about clusters and moving databases between servers. Is there
anything out there that lists the steps involved with performing an
inter-forest domain migration of a non-clustered SQL server?

Thanks in advance for any assistance.

wrote in message
news:89551a3c-07fe-459a-95c0-cbe77c91bb4b-at-y38g2000hsy.googlegroups.com...
> We will be migrating several SQL servers (non-clustered) to a new
> Active Directory domain in a seperate forest. We plan on using the
> ADMT to migrate the computer and user accounts. Other than adjusting
> the startup accounts on the SQL services, is there anything else I
> need to be aware of?
>
> I did find some KB articles and other posts, but they mostly talk
> about clusters and moving databases between servers. Is there
> anything out there that lists the steps involved with performing an
> inter-forest domain migration of a non-clustered SQL server?
>
> Thanks in advance for any assistance.

Hi

Unless you are renaming the machine there should not be any problems. If you
do rename the server look at http://support.microsoft.com/kb/303774/en-us

You will also need to map sids for logins see
http://support.microsoft.com/kb/298897/en-us for changing the domain for the
logins.

John

On Aug 28, 2:47*am, "John Bell" wrote:
> wrote in message
>
> news:89551a3c-07fe-459a-95c0-cbe77c91bb4b-at-y38g2000hsy.googlegroups.com...
>
> > We will be migrating several SQL servers (non-clustered) to a new
> > Active Directory domain in a seperate forest. *We plan on using the
> > ADMT to migrate the computer and user accounts. *Other than adjusting
> > the startup accounts on the SQL services, is there anything else I
> > need to be aware of?
>
> > I did find some KB articles and other posts, but they mostly talk
> > about clusters and moving databases between servers. *Is there
> > anything out there that lists the steps involved with performing an
> > inter-forest domain migration of a non-clustered SQL server?
>
> > Thanks in advance for any assistance.
>
> Hi
>
> Unless you are renaming the machine there should not be any problems. If you
> do rename the server look athttp://support.microsoft.com/kb/303774/en-us
>
> You will also need to map sids for logins seehttp://support.microsoft.com/kb/298897/en-usfor changing the domain for the
> logins.
>
> John

Hi John,

Thanks for the reply. The KB article you refer to is used when a
database is moved to another server. My situation involves moving the
server itself to a different domain, the databases will not be moved.
Do I still need to map SIDS?

The method we are using for the migration involves migrating the SID
history as well for the users. So olddomain\user1 should match up to
newdomain\user1. Should that be enough for SQL?

Thanks.