Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

AD name change Old name still persists Expand / Collapse
Author
Message
Posted Wednesday, April 17, 2013 6:36 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 9, 2013 8:19 AM
Points: 179, Visits: 751
After a user change of name in AD. SQl still shows the user as the previous credentials
Ie
Domain\Usernameold
Domain\Usernamenew
Although the users name has changed to the new account the old one still persists in SQL.
Domain\Usernameold no longer exists as it cannot be added to a test server as a domain login.
SQL must be caching the credentials and marrying them up with the SIDs. How to remove this from the cache.
Post #1443222
Posted Wednesday, April 17, 2013 6:47 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 9, 2013 8:19 AM
Points: 179, Visits: 751
The user is a member of an AD group which has access to SQl. They have been removed and the added back to this group with no success.
Post #1443230
Posted Wednesday, April 17, 2013 7:08 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 7:46 AM
Points: 6,619, Visits: 14,185
has the user been added as an explicit server login on the sql server.
What are the resultsd of the following query

select name, SID 
from sys.server_principals
where type = 'U'
and name = 'domain\username'



-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1443242
Posted Wednesday, April 17, 2013 7:20 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 9, 2013 8:19 AM
Points: 179, Visits: 751
No, Its a simple user who is part of a AD group.
Post #1443251
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse