Dark Developments Where Knowledge Meets Power


AX2012 – Restore AX Database from different domain

Most of our developers have done a massive customization in our own lab on premises. But what if you need to restore that database on the customer's premises. Well restoring it is like any other database but what happens when you open Microsoft Dynamics AX ? You'll not even able to login to the database. Why, well the issue is that the SID of your current user is not in the 'UserTable' for AX and thus not allowing you to access AX.

In order for the user's Microsoft Dynamics AX account to log into the restored database environment, their domain account must be a user in the system.  Microsoft Dynamics AX 2012 is integrated with Active Directory.  The account information in the database must match the user and or domain in the new environment. This needs to be done by using the following query and by using the current SID of the user you want, the SSID can be found by using regedit.

Next after you have found your SID, update the userinfo DB by using the following query.

update userinfo set SID='', Networkdomain = '<Network_domain_name>', networkalias = '<Network_alias>' where id = 'admin'

Start Dynamics AX again and you should be able to login without any issues.

Source: http://community.dynamics.com/product/ax/axtechnical/b/axsupport/archive/2011/09/02/steps-to-restore-an-ax-database.aspx
Source: http://blogs.msdn.com/b/axsupport/archive/2011/11/07/moving-between-microsoft-dynamics-ax-2012-environments.aspx

Print Friendly
Comments (0) Trackbacks (0)

No comments yet.

Leave a comment

No trackbacks yet.