Microsoft Dynamics AX 2012/r2: Database Restoration

Today, I'm writing this blog just incase I need to know how to restore "Dynamics AX 2012" database from a different machine later. :D

Steps that need to be done prior restoring "MicrosoftDynamicsAX" database are:

• From table "SysServerConfig", take the values of "ServerID", "ServerGUID" and note it down somewhere

• From table "UserInfo", take the values of "Company", "SID", "NetworkDomain", "NetworkAlias"

After restoring the database "MicrosoftDynamicsAX" from different machine, you'll receive an error that says, "Enable to logon on Microsoft Dynamics AX 2012: Event ID:110"

Recommended Solution:

We need to configure Server / Client side settings on SQL Server – DynamicsAX tables. I’ll show you how to do that in simple steps

• In table "SysServerConfig" insert/update the values of [ServerID, ServerGUID] from the values we noted down earlier

• In table ‘UserInfo’ insert/update the values of [Company, SID, NetworkDomain, NetworkAlias ] from the values we noted down earlier

That's it for now. I'll be glad if it helps someone.

The Prophet Muhammad (peace be upon him) said: "Do you know who is most generous? ... God is the Most Generous, then I am most generous to humankind, and the most generous people after me will be those who will acquire knowledge and then disseminate it. (They) will come on the Day of Resurrection singly, like a ruler." Al-Tirmidhi, Hadith 93