"Index cannot be created on view 'ReportingVirtualDataAreaView1'" error during Management Reporter 2012 CU14 deployment
Error in Management Reporter 2012 integration log:
Index cannot be created on view 'ReportingVirtualDataAreaView1' because the underlying object 'DIRPARTYTABLE' has a different owner.
This will occur when the Dynamics AX database resides on SQL 2008 R2 and earlier and the Dynamics AX integration account specified in the deployment is different from the account running the AOS.
Run the following script on the Dynamics AX database to grant authorization on the ReportingIntegration schema to dbo:
ALTER AUTHORIZATION ON SCHEMA::ReportingIntegration TO dbo
This error only occurs on SQL 2008 R2 and earlier.
Article ID: 3149466 - Last Review: 03/29/2016 07:02:00 - Revision: 1.0
Microsoft Dynamics AX, Microsoft Dynamics AX 2012, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R3 CU8, Microsoft Management Reporter, Microsoft Management Reporter 2012
- kbmbsmigrate kbsurveynew KB3149466