AD migration and SQL server logins.

From: anthonyp (anthonyp_at_discussions.microsoft.com)
Date: 02/09/05 

Date: Wed, 9 Feb 2005 07:29:16 -0800

Our SQL 2000 servers use Windows authentication. My question pertains to the
effect an AD migration has on SQL logins.

After the NT4 user accounts and groups are migrated to the AD domain and the
SQL server is upgraded to the AD domain, do the SQL logins automatically
reference the new user accounts in AD? If not do I have to manually add the
AD users and groups to SQL login and access to the databases? Or are there
tools available?

Relevant Pages

  • Re: reaching the 50 user barrier on SBS 2000
    ... transition pack after that if it looks like we are going to outgrow early... ... we have around 45 user accounts now on the system - but not all of them are ... > The migration pack alone costs more than that + you need to get migration ... > replacement of the servers in that period that I didn't take into account. ...
    (microsoft.public.backoffice.smallbiz2000)
  • Help Exchange 5.5 and 2003 in different domains
    ... I have migrated some user accounts but want to be able to use both servers ... as migration will take a long time. ... internet accounts our 5.5 uses this ...
    (microsoft.public.exchange.setup)
  • Re: Migrate 2003 users to another 2003 box
    ... > You may want to try to use the ADMT (Active Directory Migration Tool) to ... > migrate all the user accounts first. ... >> After a recent company merge we have decided to merge both Exchange ... >> 2003 servers data. ...
    (microsoft.public.exchange.admin)
  • Re: Migrate 2003 users to another 2003 box
    ... You may want to try to use the ADMT (Active Directory Migration Tool) to ... migrate all the user accounts first. ... > 2003 servers data. ...
    (microsoft.public.exchange.admin)
  • Re: how can set one password
    ... Servers on three saperate machines. ... I want my SQL logins to be ... password i want to login to three saperate servers. ...
    (microsoft.public.sqlserver.security)