March 13, 2026 at 3:38 pm
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
March 14, 2026 at 4:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
March 15, 2026 at 4:16 pm
If your domain admins alsomigrated the SIDs to the new domain's SIDHistory, this should keep on working
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply