RE: AD migration and SQL server logins.

From: kentish (kentish_at_discussions.microsoft.com)
Date: 02/11/05 

Date: Fri, 11 Feb 2005 06:43:01 -0800

You should not have to manually add the account again to SQL Server if your
network administrator choose to migrate the accounts with sid history. If
the accounts do not use sid history then you will need to add the accounts
back into SQL Server. I beleive one of the stored procedures you could use
is sp_sidmap.

"anthonyp" wrote:

> 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: Migrating accounts nt4 to 2k3 and SIDs
    ... BLOG --> http://blogs.dirteam.com/blogs/jorge/default.aspx ... Migrated users with sid history and fixing group membership ... and mail enables the AD accounts. ... histories work with my user accounts. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Newbie question on SQL connection
    ... > Let me educate you about SQL Server security. ... granting permissions to these accounts in SQL ... > maintain its own user accounts, which are separate from domain user ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Sql server 2005 clustered service group
    ... For each clustered service in the instance of SQL Server that you are ... administrator for the names of existing domain groups, ... Note that SQL Server accounts will not be removed from the groups if SQL ... I see with installing SS2005 cluster if forces me to use domain accounts ...
    (microsoft.public.sqlserver.setup)
  • Re: Domain Groups For Clustering Service ???? SQL Server 2005
    ... You need to manually add the service accounts you specify during setup into ... services then just add that to each of the 3 domain groups you create. ... Jasper Smith (SQL Server MVP) ...
    (microsoft.public.sqlserver.clustering)
  • Re: Newbie question on SQL connection
    ... Let me educate you about SQL Server security. ... The "Trusted Connection" error is associated with the "Windows ... granting permissions to these accounts in SQL ...
    (microsoft.public.dotnet.framework.aspnet)