Tuesday, June 27, 2017

Easy way to get SID for Microsoft Dynamics Ax

Most of the time when we restore other developer database ,or Client database 

Unable to log on to Microsoft Dynamics AX” error message when opening the AX client”

   we want to get the SID for the current user setting, here are the steps you  can perform to successfully log on to Dynamics AX:
1. Open the command prompt and type "wmic path win32_useraccount where name="{Domain user name}" get sid"  Press Enter
                                               OR
    Run CMD as administrator and write command "WHOAMI /USER" it will return 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'

OR 

3. You can find UserInfo table under Microsft Dynamics AX 2012 Database.
     (a). Right Click on table node --> select Edit rows -- > Update SID where ID = Admin
     (b) Replace  Network Alias   with your user domain name example "Daniyal.aslam" in               my case.
     (c) Replace NetworkDomain  with your domain name example "abc@contoso.com" in               case when we copy database from Client or Live environment where domain name is             different from Production environment

No comments:

Post a Comment