Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Deploy Datamart Database Management Reporter 2012

Posted on by 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

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Deploy Datamart Database Management Reporter 2012

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

  • cgust Profile Picture
    cgust on at
    Re: Deploy Datamart Database Management Reporter 2012

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans