What happens to AD accounts when domains change?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nar12755@gmail.com - 21 Mar 2008 15:08 GMT

Specifically in SQL Server 2000. We bought a small office (DOMAIN_A)
and need to convert the existing domain users into our domain
(DOMAIN_B). The AD admin is going to migrate the DOMAIN_A users into
our DOMAIN_B.

There are a handfull of DOMAIN_A users with logins in SQL2000. From
what we have been told, the applications using the database use the
SID for the credentials. My question is will these users work as
before after the change?

What I think will happen is basically this:
BEFORE
DOMAIN_A\joe_smith

AFTER
DOMAIN_B\joe_smith

And all will be good. At least I think (hope!, maybe pray?) will
happen.

If not, what have others done in cases like this?

Thanks!
Norman

Reply to this Message

John Bell - 22 Mar 2008 14:02 GMT

Hi

If you use admt you can keep the sids, but if not you will need to check the
logins. A script such as
http://support.microsoft.com/kb/918992/ will help, but if you used windows
groups and not individual accounts then you would need to far less work, so
this may be a chance to rationalise.

You may also want to look at http://support.microsoft.com/kb/246133/

John

> Specifically in SQL Server 2000. We bought a small office (DOMAIN_A)
> and need to convert the existing domain users into our domain
[quoted text clipped - 20 lines]
> Thanks!
> Norman

Reply to this Message