Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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:

ALTER LOGIN OldName WITH NAME = NewName; 

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
1  
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

 
discard

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.