Wednesday, 17 December 2014

Failed to create a session confirm that the user has the proper privileges in ax 2012

Failed to create a session confirm that the user has the proper privileges in ax 2012 R3
The error occurs in different Scenario's like restore Demo database in AX 2012 R2, Database Synchronize error after loading license file in Ax 2012 R3.
UserInfo table doesn't have the records for Partitions keys PS and ext from Partitions table in SQL.
create new users in Ax and map update the Userinfo table with the two users which we created newly

UPDATE USERINFO
SET ID = 'Admin', Name = "name of the new user", Enable = 1, SID = "sid of the new 
user",NETWORKDOMAIN = '[domain]', NETWORKALIAS = '[alias]',PARTITION = 
"recid for 'ps' from partition table"
WHERE ID = 'id of the new user'  
After running the script in SQL, uncheck the Enabled button for the newly created  
user. 
Database Synchronized done without any error.

No comments:

Post a Comment

Calculate ledger balance by dimension set in X++ in AX2012/Dynamics 365 FO

There are a variety of ways users can view balances in the general ledger. Some of the most common options are: 1. Trial balance 2. Financia...