Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Deploy Datamart Databa...

Deploy Datamart Database Management Reporter 2012

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello,

I am installing MR 2012 RU3 on a client using Windows Server 2003. I was able to deploy the ManagementReporter database without issue using the command prompt provided in the install guide.

I am now trying to deploy the datamart, but am receiving an error. I am running the comand prompt as admin and using the following script:(I replaced their domain and SQL server for security)

MRDatabaseDeploy.exe /action:create /databasetype:DataMart /servername:SQLSERVERNAME
/databasename:DDM /servicedomainuser:DOMAIN\MRservice

When I run that script I get the following:
Extracting supporting files for database deployment...
Beginning database deployment...
The database deployment failed. Additional information: Could not deploy package.

Any suggestions to resolve would be greatly appreciated.

*This post is locked for comments

All responses (2)

Answers (1)

Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

Re: Deploy Datamart Database Management Reporter 2012

Well, this one was my fault. The DataMart is not supported in SQL 2005.
cgust on at

Like (0)

Report

Re: Deploy Datamart Database Management Reporter 2012

blogs.msdn.com/.../how-to-use-the-database-deployment-tool-for-windows-2003.aspx