Error 15401: Windows NT group or group not found

[kim]

I have a user in SQL Server with a NT login of Mike
I changed his NT account to Mikel in User Manager

Now when I try to add Mikel, Im getting error 15401.

Do I need to delete NT login in SQL Server 'Mike' account first ?..before adding 'Mikel' ?

Can I go into the Master database and just change Mike login to Mikel ?

Thank you

[rmiao]

Delete mike first in sql since it's not in domain any more then add mikel as sql login.

[kim]

Thank you...but is there no way to tell SQL Server that 'MIKE' has changed to 'MIKEL' and that all permissions and jobs belonging to MIKE should now belong to MIKEL ?

A weird thing is that I tried adding MIKEL to 2 different SQL Server 2000, where MIKE already exists and it let me do so, whereas on another 2 SQL Servers I was NOT able to add MIKEL, where MIKE already existed

[rmiao]

You can't change sql login name in sql.