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) / Mgmt Reporter FP1, Mig...
Microsoft Dynamics GP (Archived)

Mgmt Reporter FP1, Migration Wizard error

(0) ShareShare
ReportReport
Posted on by RaySisler 205

We are trying to run the Migration wizard on SQL "ManagementReporter" database.  The connection test is successful, but when we click next we get "The database selected is not a management reporter database" message. 

Thanks

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    RE: Mgmt Reporter FP1, Migration Wizard error

    I have made the User as part of the db_datareader, db_datawriter, General User and public but still getting the same error message.

    I realized that there were two MR Migration Wizard installer in the MR CU14 download.  I uninstalled the older one and reinstalled the correct version and voila, went through with the migration just fine.

    Cheers!

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell on at
    RE: Mgmt Reporter FP1, Migration Wizard error

    I would like to confirm that until you make the user you are connected to the system as - likely Administrator - a properly configured user in SQL you will not be able to complete the process.

    Admin_5F00_SQL_5F00_Permissions.GIF

    Once completed, the error was solved.

  • Suggested answer
    Elizabeth James Profile Picture
    Elizabeth James 5 on at
    Re: Mgmt Reporter FP1, Migration Wizard error

    I received the same error "The database selected is not a Management Reporter database"...

    I checked the SQL roles assigned to my user for the Management Reporter database, and it had the following:

    - db_datareader

    - db_datawriter

    - public

    So I decided to try adding the role "GeneralUser" to my user, and then I relaunched the Migration Wizard and was able to walk through it without error.

  • Nate Bork Profile Picture
    Nate Bork 310 on at
    Re: Mgmt Reporter FP1, Migration Wizard error

    Thanks for the reply.  I was logged on as Administrator.  I am not sure what the issue was.  I unistalled Management reporter (client, server, connector) and reinstalled them.  That fixed it for me.

  • Ryan Sandness Profile Picture
    Ryan Sandness on at
    Re: Mgmt Reporter FP1, Migration Wizard error

    There could be a few different things going on here. First off, be sure to be logged in as an administrator with sufficient rights to the database. That could potentially cause issues with the migration since local users won't have any rights to the MR database.

    For the company issue, please be more specific about it not connecting. Also check the Windows Application Event Log for any error messages on both problems.

    Thanks

    Ryan

  • Nate Bork Profile Picture
    Nate Bork 310 on at
    Re: Mgmt Reporter FP1, Migration Wizard error

    Did you resolve this.  We are getting the same error.

    Also, I can launch the Report Designer fine but if I try to set up a company it does not connect to the database.

  • Jill Carter Profile Picture
    Jill Carter 1,846 on at
    Re: Mgmt Reporter FP1, Migration Wizard error

    Are you able to launch the Report Designer component of Management Reporter?

    Jill

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,575 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans