• Vedran is right. If you manage security via AD Groups, all you need to do is remove the old login from the group - typically server team does this, and have the new login added to the domain group.

    SQL Logins are typically meant for application logins. People generally are required to use their domain logins to connect to SQL.

    I have also seen some people using same old domain login even after name change.