Hi,
I have a SQL Server instance where users connect to via Windows Authentication, so for each user there is a row in sys.server_principals with (as example) "DomainA\JohnDoe". Recently a lot of users were migrated to DomainB (same forest) using the ADMigration wizard. Although I haven't created a new "DomainB\JohnDoe" login, this user is still able to connect to the SQLServer as "DomainB\JohnDoe". Even "sp_who" shows me "DomainB\JohnDoe".
What is the best way to change (ALTER) the login, so that it reflects the proper user (DomainA\JohnDoe --> DomainB\JohnDoe)?
Thanks,
Adri