Monday, June 25, 2018

Error in Getting SID in Dynamics AX 2012


In Dynamics AX 2012, while doing changes in Tools -> options -> Status bar and ----- "error in getting sid" and can’t save the changes.

This issues comes up every now and again.

The SysUserSetup form tries to update your SID every time you update your settings.

It uses network alias and domain name to find out the "actual" SID.

When it fails (for instance, your current SID in AX is valid but your network alias/domain name are not) then it might error  "invalid arguments passed to getUserSid

This error comes when either the SID,network alias or network domain for the admin user in Userinfo table is incorrect.

The easiest fix is to disable the user, then enable.

You can check the table using the query” select SID, NETWORKDOMAIN, NETWORKALIAS, * from UserInfo where Id = 'Admin'

( but you should obviously set your own network domain and alias when running that query, not just a blank query.)

You can correct using :

update USERINFO set SID = 'SID', NETWORKDOMAIN = '', NETWORKALIAS = '' where Id = 'Admin'

(To obtain the SID enter whoami /user in cmd)



Scenario;

The administrator of AX imports your user and you can start working in AX.

The system administrator alters your information (e.g. your name) in Active Directory after your user is imported into AX.

Then you experience the SID error. The resolution is to  import the user from the AD again.

". A workaround is to create another user with System Administrator role and change its SID to yours while also clearing the "admin's SID.



Summary:

1.      You need to make sure that User SID is correct,.

2.       To view and change individual SID in SQL Server , Open Microsoft Dynamics AX Database and go to SysUserInfo Table and look for SID Column.

3.      Open Microsoft Dynamics AX Client and make sure that User NetworkDomain and NetwokAlias are correct based on your current Domain Controller.

4.      Check the UserInfo Table under AOT > System Documentation > Tables > User Info.

No comments:

Post a Comment

if you have any doubts, please tell me

More Than One Form Was Opened at Once for the Lookup Control

In Dynamics 365 for Finance and Operations, when subscribing to a lookup event to modify an existing lookup on a form control, you must...