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 

select * from dbo.SECURITYUSERROLE
delete from dbo.SECURITYUSERROLE where USER_ = 'v-vimsin'

Happy DAXing.....