AD migration and SQL Server

[Jose Cebrian]

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

 

[Ryan Hanisco]

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.