February 28, 2016

Management Reporter Integration failed with error “The REFERENCES permission was denied on the object 'DATAAREA', database ‘XXX_XXX_XXX’, schema 'dbo'.Rolling back transaction “ in AX2012R3

Solution : As per the error, the account which we used to run MR services has no ‘References ’ permission on DATAAREA table, on transaction database. To over come this error we have to provide required rights as per the below screen.

Connect to SQL Server --> Open SQL Managament Studio --> Expand ‘database’ --> Expand ‘Security’ --> Select ‘MR Service account’ --> Click on ‘Securables’ --> Select ‘DATAATEA’ and ‘Reference’ Tick Mark on ‘Grant ’ --> Click ‘Ok’.

Now goto Management ‘Configuration console’ stop and Start Integration, it will finish without any errors.

"Yours Ravi Theja Madisetty"