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.





