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

Microsoft Dynamics AX

http://msdynamicsaxtips.blogspot.in/

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh