AD migration and SQL Server

  • Thread starter Thread starter Jose Cebrian
  • Start date Start date
J

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
 
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.
 
Back
Top