AD migration and SQL Server

[Guest]

Archived from groups: microsoft.public.win2000.active_directory (More info?)

I have migrated my NT domain to AD. I keep sid history for all users.
But nobody can access to SQL Server. Users that have access to this
database appears NTDOMAIN\USER, but sid history doesn't work.

Do I have to change each user to ADDOMAIN\USER?? Is there any way to do
this automatically?

Thanks

 

[Guest]

Archived from groups: microsoft.public.win2000.active_directory (More info?)

Jose,

Unless you have a real specific need to provide user-by-user permissions to
your SQL databases you should allocate permissions by group rather than
individual user. Adding the users to these groups is a good way to maintain
access across a migration.

Verify that the SIDHistory did migrate using ADSIEdit and consider
re-permissioning your SQL databases with groups.

--
Ryan Hanisco
MCSE, MCDBA
FlagShip Integration Services
Chicago, IL

"Jose Cebrian" <jcebrian2002@yahoo.es> wrote in message
news:OHU92eVKFHA.3420@tk2msftngp13.phx.gbl...
>I have migrated my NT domain to AD. I keep sid history for all users. But
>nobody can access to SQL Server. Users that have access to this database
>appears NTDOMAIN\USER, but sid history doesn't work.
>
> Do I have to change each user to ADDOMAIN\USER?? Is there any way to do
> this automatically?
>
> Thanks