Saturday, September 14, 2013

You are not recognized as a recognized user of Microsoft Dynamics Ax

You may this error when you have to import an AX database from some other environment of different domain e.g. your client's DB. In this case once you import the db and start Ax, it will throw the following error:








Now this happens because of the change in domain(new domain and users are not logged in AX DB) so we need to add users of our domain to this DB. For this we need to add an entry with SID of our "Admin" account to the "USERINFO" table.



Follow the steps:
  1. Get the SID of Admin account.
  • You can also get SID from an existing AX DB in your environment by using the SQL command:
select SID, Networkdomain, networkalias from userinfo where networkalias = '<UserAlias>'
  1. Open SQL Server Management Studio.
  2. Run the provided query
update USERINFO
set NETWORKDOMAIN = 'contoso.com', NETWORKALIAS = 'axadmin', SID = 'S-1-5-21-2423567575-2897528880-3809357285-500'
where id = 'admin'

where NETWORKDOMAIN is the DomainName of your environment where you have restored the DB and NETWORKALIAS is the username to which you want to provide access(Admin in this case).

1 comment: