A small thing to remember when moving a SQL server MS Dynamics AX 2012 R2 database from one Windows domain to another Windows domain

If you create a backup of your SQL server MS Dynamics AX 2012 R2 database in Windows domain 1, copy it to Windows domain 2, restore the back there you will probably be able to start the AOS server in Windows domain 2 successfully (Note: Do not forget to move the MS Dynamics AX 2012 R2 model store database as well). However if you start an MS Dynamics AX client in Windows domain 2 then you might face the following message: “A user session on the server could not be created”

The solution here is to have a look back to your SQL server installation in Windows domain 1. There is a stored procedure called “createusersessions”. Script this stored procedure using SQL server management studio and apply this stored procedure as well on the SQL server instance in your Windows domain 2.

For more hints regarding what should be considered when you move a MS Dynamics AX 2012 environment from one Windows domain to another, have a look here if you like: