Added AX user using the command in AX 2012

 

You can replace the admin user’s SID field with yours and you can log in afterward.

 To get your SID open a cmd and run this:

Whoami /all

 Then scroll back to the top and you should see something like this:

C:\Users\xyz>whoami/all

 

USER INFORMATION

----------------

 

User Name SID

========= ============================================

test\xyz   S-1-5-21-123456789-xxxxxxxxx-xxxxx-xxxx

 

Grab the SID and put it in this SQL update script, replace the DB name,  name and network alias (and maybe the domain too, not sure about that) and run it on the data database

 

UPDATE [AXLocal].[dbo].[USERINFO]

SET SID = 'S-1-5-21-123456789-xxxxxxxxx-xxxxx-xxxx',

NETWORKDOMAIN = 'test.xyzit.com',

NETWORKALIAS = 'xyz',

NAME = 'xyz',

SHOWAOTLAYER = 1,

SHOWMODELNAMEINAOT = 1

where ID = 'Admin'