I have a user who was added with windows authentication to a SQL Server 2008 R2 machine.
He had left the company a few months ago, at which point his AD user was disabled and moved to a different OU.
The users database logins and users were not affected.
He then returned to the company, his AD user was reactivated, and moved to the correct OU.
However all his database logins are currently giving login failures.
The issue is resolved if the following actions are taken:
- Drop the existing login
- Create the login again
- Remap the login to the existing database users
This is an impractical method, as it means tracking down each login and recreating it.
How can I resolve this in a more practical way?
Failing a more practical solution, what is the cause for this issue?