web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Issue with the AX user when renaming the user in the AD profile

(0) ShareShare
ReportReport
Posted on by 120

Hi.

It appears that I am not the first one to experience issues with AX users linked to AD profiles.

My problem is with a user which had his name and email address changed in AD.

When the name was changed, AD changed the user Log On which now no longer matches the AX alias.

I guess that the auth. to AX works based on the user's SID (which remained unchanged) as the user is still able to log in to AX.

My problem is that the AX account is behaving strangely. We recently made some changes to a security role which apply as expected to all users except for the one that had the name changed.

I tried to delete the user in AX, re-import his account and potentially modify his user ID in AX (for backwards audit consistency).

Unfortunately, I get stuck here.

AX returns the following errors:

1. when trying to delete the user

Stack trace: The company  does not exist.

Stack trace

(S)\Data Dictionary\Tables\SysUserInfo\Methods\Delete - line 21

2. When trying to update the user (i.e. disable the account)

The Active Directory user or group does not exist. Contact your network administrator.

3. When trying to update the user's options (i.e. modify the email settings)

Error in getting SID (although querying the DB shows that the SID in the AX user profile = SID in AD)

 

This is getting really frustrating. I have other users that will potentially experience the same issues when their names will change (i.e. someone getting married).

I thought of updating the user's alias directly on the DB and try to repeat the steps for deleting the user - however I'm not comfortable in experimenting such changes.

Does anyone have any suggestions on how to fix this?

 

 

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Denis Macchinetti Profile Picture
    16,444 on at
    RE: Issue with the AX user when renaming the user in the AD profile

    Hi Dragos

    Go through AOT, System Documentation, Tables

    Open the UserInfo table, update the networkalias field with the new value present in AD for all users that have changed name.

  • Suggested answer
    Kenny Saelen Profile Picture
    on at
    RE: Issue with the AX user when renaming the user in the AD profile

    Run the following on your AX Data Database: (Replace the Domain and username to the one you need)

    UPDATE USERINFO

    SET NETWORKDOMAIN = 'Contoso.com'

    , NETWORKALIAS = 'USERNAME'

    , SID = 'SIDFROMTHEREGISTRY'

    WHERE USERINFO.ID = 'IDOFUSERTOCHANGE'

    You can find the right SID in the registry in the path: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList

    There you will find folders with SID's of users (that have logged in), just scroll through them until you have the user you want to get the correct SID.

  • Dragos Profile Picture
    120 on at
    RE: Issue with the AX user when renaming the user in the AD profile

    Thank you Denis and Kenny.

    Your suggestions make perfect sense. I will try to run the update in the test environment and let you know if it fixes the problem.

  • Dragos Profile Picture
    120 on at
    RE: Issue with the AX user when renaming the user in the AD profile

    Thanks both.

    I was able to fix the link between the AD profile and AX user.

    It's furstrating to see that MS doesn't provide a more reliable solution for a key integration between two MS products such as identity management?

    I'm not in favour of running update scripts at DB level...

  • Community Member Profile Picture
    on at
    RE: Issue with the AX user when renaming the user in the AD profile

    Denis, I updated the  networkalias in the uesrinfo table for the user who changed names in AD but the user is still not able to run reports in AX. I tried to use the function in AX that lets you change a user ID and I get an error message that the new user id already exists - I guess that's because we created the new user id as to rectify this but since it didn't help we deleted it but the system thinks it's still there. I looked in the userinfo table and I only see the old user id for which I updated the networalias. Any help is much appreciated.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

#2
NNaumenko Profile Picture

NNaumenko 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans