Most of the time when we restore other developer database ,or Client database
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'
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