Management Reporter 2012 compatibility with Microsoft SQL Server 2017
Management Reporter 2012 is currently not compatible with Microsoft SQL Server 2017. When you try to install Management Reporter 2012 on SQL Server 2017, you receive this error:
The database deployment failed. Additional information: Microsoft.SqlServer.Dac.DacServicesException: Could not deploy package. —> Microsoft.Data.Tools.Schema.Sql.Deployment.DeploymentFailedException: Unable to connect to target server.
There are no plans to support Microsoft SQL Server 2017 with AX 2012 R3. As such, Management Reporter 2012 is also not supported with Microsoft SQL Server 2017. MR 2012 is supported with a minimum of SQL Server 2012 Standard Edition and the recommend being SQL Server 2016.
Update — MR CU16 v2 has added support for SQL 2017. You can find out more about the updated CU16 release here.
Dynamics AX 2012 R3 is still not supported with SQL 2017, so the AX database would need to be separate from the MR databases if you are planning to use SQL 2017.
You can download the updated build of CU16 here.
