One of the Active Directory users was renamed or it's SID was changed. Now you may encounter errors like Error in getting SID in Dynamics AX.
You need to update Userinfo table 

Connect to the Database Server and start the Microsoft SQL Management Studio to connect to your AX Database. Once connected, find the table USERINFO. From that table you will be able to update the User's domain, network alias, Full Name and SID :

Create a new query and adapt the fields as required :

UPDATE USERINFO
SET NETWORKDOMAIN = 'DOMAINNAME'
,NETWORKALIAS = 'NEWNETWORKALIAS'
,NAME = 'NEW Name'
,SID = 'NEW SID'
WHERE USERINFO.ID = 'ACTUAL-AX-USER-ID'

Now simply execute the query to update the AX user information to match it's actual information from Active Directory.

blog comments powered by Disqus