Failed to create a session; confirm that the user has the proper privileges to log on to Microsoft Dynamics Axapta R2- R3

Hi all ,

I faced this error in AX R3 "Failed to create a session; confirm that the user has the proper privileges to log on to Microsoft Dynamics" , so did some research. 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 reimport 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:

DECLARE @NetworkDomain nvarchar(255);

DECLARE @NetworkAlias nvarchar(80);

DECLARE @SID nvarchar(124); DECLARE @InitialPartition BIGINT;

 

SELECT @InitialPartition=Recid FROM PARTITIONS WHERE PARTITIONKEY=N'Initial'

 

SELECT @NetworkAlias=NETWORKALIAS,@NetworkDomain=NETWORKDOMAIN,@SID=SID FROM USERINFO WHERE PARTITION=@InitialPartition AND ID = N'Admin'

 

UPDATE USERINFO SET NETWORKDOMAIN=@NetworkDomain,NETWORKALIAS=@NetworkAlias,SID =@SID WHERE PARTITION != @InitialPartition AND ID = N'Admin'