March 2, 2004 at 4:09 pm
Hi there, I have a user who recently got married and her last name got changed. Her windows username has therefore changed. I tried to give her new username access to the database and I get the following error:
Error 15401: Windows NT user or group 'DomainName\NewUsername' not found. Check the name again.
And also, she is still able to log in to the databases under her old username. Well, she logs in to her computer with the new username, and then connects through QA using Windows Authentication to the databases that have the old username. What is going on here??????????????????
Thanks in advance for your help.
March 2, 2004 at 4:33 pm
It sounds like you use windows trusted connection to SQL Server. If that is the case, you do nothing.
March 3, 2004 at 1:30 am
Make sure your domain administrator have changed her last name first in windows user account.
After that, drop her old account ( or just denied it in case you'll need the permission information ) and give the new windows user access to the database.
March 3, 2004 at 6:52 am
The domain admin probably just renamed her account, so the SID is unchanged. That SID is stored in master..sysxlogins, which also remains unchanged. That's why the "new" user id has access to SQL Server. If you do as Hendra said, that should clean things up for you.
March 3, 2004 at 9:10 am
Hi everyone, thanks for your help. I am not sure what you mean by
"Make sure your domain administrator have changed her last name first in windows user account. "
Her username has been changed already on the windows level, if thats what you mean. I am not a sys admin, so I am probably misunderstanding what you said, can you please explain it a little more? Thank you.
March 3, 2004 at 10:11 am
I ran into this exact situation a couple months ago. Before you can add the user to any new access or change any existing acces you must completely remove her user ID from all databases then the server. Then add her back in with new ID. I ensured her continued access during the process by giving a windows group that she was a member of (with new window login) to all the current access she has.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply