Dynamics Community Forum Thread Details

MR 2012 CU16 on SQL 2019

Trying to install MR 2012 CU16 on SQL 2019. According to the CU16 HF list, SQL 2019 is supported with BugID 337780.

Getting the following error attempting to create a new SL DataMart:
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 master or target server 'ManagementReporterDM'. You must have a user with the same password in master or target server 'ManagementReporterDM'.

I successfully migrated the ManagementReporter DB from another server and that one is connected fine. (When I tried to create a new ManagementReporter database on SQL 2019, I got the same message, only with the ManagementReporter DB name instead).

I then tried to create ManagementReporterDM to a different SQL Server (2014) and it creates fine.

Wondering if anyone else out there has been successful in creating an MR database on SQL 2019 (or any version higher than 2014).

Trying to determine if I have another variable denying this in SQL 2019 that I need to figure out. Have done some research that one issue may be that the SSDT tools are not up to date, but I have VS 2019 installed (which comes with it) and have run VS updates to get the latest version.

Thanks.