sql 2005 server showing old AD account name

yuggol
yuggol used Ask the Experts™
on
I have a microsoft server 2003 network with 8 servers. 2 servers running A/D, 3rd server running sql 2005. Sql server 2005 is using windows authentication for access to databases (mostly through group membership). Last month we had a girl in the office get married. When she returned to work we renamed her A/D account from domain\madien name to domain\married name. Account rename went fine, all Exchnage modifications went fine. Appears that all servers recognize the new domain\married name account except the SQL server. We are running a canned accounting system on the SQL server, all security changes in the accounting package were completed & she can run the application without problems. The problem that I am still having is that when I examine the SQL activity monitor, it shows her user as domain\madien name. Does anyone know why? The odd part is that we went through this process about 2 months ago for another girl who got married & she appears in the activity monitor with her new account name. The only difference between the 2 may be a server restart.

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Topic Advisor, Page Editor
Distinguished Expert 2018
Commented:
Havent come across that myself (from memory), but would suggest a service restart would resynch AD.

In SQL Server there are logins and users it probably picks up the new credentials directly from AD for login, and cannot imagine why it wants to retain the old name other than it does recognise / is cognisant of the name change.

Would be interesting to run : EXEC sp_validatelogins

And to look at : select * from sys.server_principals


In the meantime, I will have a look around to see if I can find something "concrete".

Author

Commented:
I resolved this issue by restarting all of the SQL server services.
Mark WillsTopic Advisor, Page Editor
Distinguished Expert 2018

Commented:
Yep, thought that would do it.... It is amazing what a SQL server restart can achieve.

Still I am a bit surprised that it was recognising the original name. Did you run those queries at all ?

Author

Commented:
Didn't have a chance to run the queries, restarted the services @ 5:00 am - long before I saw comment. The selection from  sys.server_principals would not have shown me what I needed since she connects via group membership.
Mark WillsTopic Advisor, Page Editor
Distinguished Expert 2018

Commented:
Right.... thanks for getting back.... good information :)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial