SYSTEM_USER returns old username

Question

Post reply

SYSTEM_USER returns old username

bjorn.hilde

Old Hand

Points: 379
More actions
March 8, 2010 at 10:20 am

#217644

We are currently renaming all of our domain users (they are still in the same domain)
The problem is that after renaming a user SYSTEM_USER still returns the old name. It will give the new (proper) name after restarting the sql-service.
Are there any less drastic ways of forcing sql server to update it's usernames? 😉
Many thanks in advance!

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

you can use the ALTER LOGIN command, i believe.

--name change due to marriage

ALTER LOGIN [DOMAIN_NAME\gallan] WITH NAME = [DOMAIN_NAME\gshepherd];

--domain name change?

ALTER LOGIN [DOMAIN_NAME\lowell] WITH NAME = [NEW_DOMAIN\lowell];

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

bjorn.hilde Old Hand Points: 379 More actions · Answer 2

Thank you for your quick reply!

Unfortunately the user is not sql user but he is in a active directory group. And that group is created as a login in SQL Server.

RBarryYoung SSC Guru Points: 143329 More actions · Answer 3

Unfortunately, it can take a while for AD changes to propagate to whatever SQL Server is using to Cache it. It have seen it take up to 24 hours for this to get straightened out.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

bjorn.hilde Old Hand Points: 379 More actions · Answer 4

Thank you!

Too bad that there is not a way to force to renew it's cache other than restarting sql services.

🙁

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 5

bjorn.hilde (3/8/2010)
The problem is that after renaming a user SYSTEM_USER still returns the old name. It will give the new (proper) name after restarting the sql-service.

Is this problem get resolved ?

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

bjorn.hilde Old Hand Points: 379 More actions · Answer 6

No unfortunately not. I still need to restart the sql services to let sql server update it's cache.

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 7

bjorn.hilde (3/10/2010)
I still need to restart the sql services to let sql server update it's cache.

your are peroidically restarting the services ?

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

bjorn.hilde Old Hand Points: 379 More actions · Answer 8

Yes, we have scheduled that to do that overnight, until we have renamed all the users..

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 9

if possible restart sql server.

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Marios Philippopoulos SSC Guru Points: 57190 More actions · Answer 10

Hi,

We are having the same problem, but it involves the renaming of a single user in Active Directory.

Do we still need to restart the SQL instance to get this fixed?

Would removing the user from Active Directory and recreating it from scratch fix it as well?

__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

rob-570113 Grasshopper Points: 13 More actions · Answer 11

Hi

Did you solve this? Im reluctant to restart SQL Server