When i install the KB Update in AX 2012 R2 and tried to synchronize DB I get error message:
Failed to create a session; confirm that the user has the proper privileges to log on to Microsoft Dynamics
A closer look into this learned that this is linked to the new partitions feature.
It seems the UserInfo table is not correctly updated and the partition administrator is not updated correctly when you restore an existing DB or the Demo database. To fix this, you can do the following.
Stop the AOS Restore the database again Start the AOS Start a client and complete the partition initialiasation checklist Close the client and execute the script below on the SQL database Restart the client and re import your license (if you were restoring the Microsoft demo data, the demo license is back in there) Then compile / generate CIL / DB sync and you should be on track again! The script for updating the UserInfo inforation is as follows:
SELECTTOP 1000 [PARTITIONKEY]
To manually create the new Admin you will need to have the SID for the user. If you are working in demo then this is Admin you might want to find the SID from the exiting user and copy that for the user you want to use.