Saturday, 3 September 2016

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

When Insert Users form System Administration Getting Error :- Cannot insert multiple records in Security user role (SecurityUserRole). The record already exists.

 
 
 

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

Select * from dbo.SecurityUserRole
Delete from dbo.SecurityUserRole Where User_='USERID'