web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Management Reporter 20...
Microsoft Dynamics GP (Archived)

Management Reporter 2012 - Can't Deploy Database

(0) ShareShare
ReportReport
Posted on by Jennifer Wheeler

I got Management Reporter 2012 installed on my GP SQL server and I am trying to configure it and it fails and in the log I get an error 'the database deployment failed'.  There is also another error before this one that says 'The physical file name '\ManagementReporter.mdf' may be incorrect.'  This is MR 2012 that just recently came out that includes service pack 1.  I can't figure out what the problem is.  Anyone else seen this before?

Thanks
Jennifer

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Cory Severson Profile Picture
    Cory Severson 695 on at

    Hello Jennifer,

    Usually this issue occurs if you try to deploy the integration when you are logged into the configuration console as a user that is not an MR Administrator.  If you look in SQL at the SecurityPrincipal table it will show you the only domain user that has been entered into the system.  That is the user that needs to be logged into the console to deploy the GP integration.

    I also have seen similar errors in the 2.0 version of MR where the default directory for a database was set to the root of C:.  Open SQL and look at the server properties and click database settings.  At the bottom you should see database default locations.  If it shows the root of a drive you will need to update that to a location that goes into at least one folder level.

    Give this a try.

  • Jennifer Wheeler Profile Picture
    Jennifer Wheeler on at

    Thanks for the reply Cory.  I got it working now.  The fix was to not have the database installed to the root of a drive.  I have my SQL to install to the root of a drive (not the C drive).  So, I changed that and got MR installed.  Personally I prefer to have all my databases located together so I don't like that MR has to be in a folder.  But, I guess that is just the way it works.

    Thanks

    Jennifer

  • Suggested answer
    Holli Verhovsek Profile Picture
    Holli Verhovsek 195 on at

    Jennifer,

    Installing at the root of the drive was the issue.  Thanks for the fix.

    Holli

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans