This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 22%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZZ%3C/text%3E%3C/svg%3E)
I have an user account ESCxxx\xxxport (AD account), created as sql login in two sql servers. One is showing ESCxxx\xxxportnew, another shows normally as ESCxxx\xxxport.
when I login on a PC and open SSMS with that AD user, the two sql server instances showing different name (see screenshot 1)
Screenshot2 shows this user's actual name is ESCxxx\xxxport in AD
screenshot3 shows when I open a sql agent job in the weird instance , it attempted to authenticate with the user in another domain (decommissioned domain) , not sure how it works and where it stored the old domain user info,
contacted MS support, but they need more time to do research. Just wondering if anyone has some answers.
Additional SQL Server features and topics not covered by specific categories
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Hi zhiqingzhou-0982,
Welcome to Microsoft Q&A.
We can use master.sys.syslogins and master.sys.server_principals to view user information.
Could you please check if wrh\xxxport is existing in the master.sys.syslogins?
Have you tried to recreate a new job?
Best Regards,
Amelia
Hi Amelia, thanks for the info. the login name doesn't exist in either syslogins or server_principals.
I looked both views, no wrh\xxxport record found. it is not in local admin group either
I initially did recreate the job first noticed, it turned out nothing to do with particular job, it is related all jobs owned by various users.
I attempted to create the login in SQL server, but it only accept the once a temporary username, not accepting the current AD user name.
I created this user on difference sql instance with current AD username, there is no issues.
see my new screenshot replied to Olaf.
Hello,
SQL Server stores the Windows login SID and name on creation of the SQL Server login and newer update it.
If you rename the Windows login name in AD, the name stored in SQL Server remain, until you manually update it.
The login will still work, because for auth SQL Server always uses the SID only and not the name.
You can update the name with ALTER LOGIN, like
ALTER LOGIN [Domain\OldName] WITH NAME = [Domain\NewName];
BTW, you can query the stored logins with
select *
from sys.server_principals
thank you Olaf always.
The user does not exist in syslogin or server_principals . cannot alter the name.
But with the hint you provided, found it was possibly stored somewhere in Windows somewhere.
