Monday, May 14, 2012

Easy way to get SID

Most of the time when we switch back and forth from staging to production environment, we want to get the SID for the current user setting, here are the steps you  can perform to scussfully logon to Dynamics AX:
1. Open the command prompt and type "wmic path win32_useraccount where name="{Domain user name}" get sid"
2. Copy the SID.
3. Open the SQL server and write following command to update current admin user:

             use {AX DB}
             update USERINFO
             set SID = '{paste the SID here from step#2}', NETWORKDOMAIN='{Network domain}',         NETWORKALIAS='{User Id}' where ID='Admin'
Post a Comment