Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We changed the username of one of the ActiveDirectory users, but now, days later the old username is still showing in SQL Profiler when they login. Are these SIDs cached locality with a copy of the username? Can I clear this cache?

The user does not have "direct" access to SQL server, but is in a local security group which has access to the server.

share|improve this question

It's not cached on the SQL Server - you can see it in the system view:

SELECT name, sid FROM sys.server_principals;

You can update the name for the LOGIN by running the ALTER LOGIN statement, similar to:


Run the SELECT statement above to see the desired change.

share|improve this answer
I forgot to mention: The user has not been added directly to SQL server, but is in a local security group. – NTDLS Feb 25 '10 at 17:08
Not 100% sure then. I'd try running xp_logininfo 'DOMAIN\GROUP', 'members' and see if there is a disparity between that user's name and his mapped login name. The mapped login name is what SQL Server is using. – Brian Knight Feb 25 '10 at 18:51

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.