Cannot insert multiple records in Security user role (SecurityUserRole). The record already exists.

Cannot insert multiple records in Security user role (SecurityUserRole).
The record already exists.


Issue: 
Cannot insert multiple records in Security user role (SecurityUserRole).
The record already exists.

AX: AX 2012 R3,
OS: Windows Server 2012
SQL: SQL 2014 


























Solution: Open SSMS, SQL DB, Select the MicrosoftDynamicsAX database and run the below query 

delete from dbo.SECURITYUSERROLE where USER_ = \’upandit\’

To check user details run:

select * from dbo.SECURITYUSERROLE

If this does not work,

Please open Ax 2012 Management Shell as Admin:

New-AXUser -AccountType WindowsUser -AXUserId upandit -UserDomain “google.local” -PartitionKey initial Enabled -UserName upandit -Company DAT

Happy AX Infra! 
Thanks & Regards,


Umesh Pandit
Mail ID: pandit.umesh@hotmail.com
Skype ID: pandit.umesh


Leave a Reply

Your email address will not be published. Required fields are marked *