April 17, 2013 at 6:36 am
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.
April 17, 2013 at 6:47 am
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.
April 17, 2013 at 7:08 am
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" 😉
April 17, 2013 at 7:20 am
No, Its a simple user who is part of a AD group.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply