Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Management Reporter data mart access - domain change

Posted on by

We just migrated to a new server for GP, and as part of that, a new domain is added as well. I have been able to add the new domain users and can access management reporter, can run reports, and can access reports if they are done on the legacy adapter. However, if they are run using the datamart or any datamart database, when the report comes up, I get a message "This report can't be displayed" "Make sure that you have access to one of the following items: A unit in the reporting tree The report in the Management Reporter report library."

If I go to the report library and try and open the report, it gives me a message: "This report view can't be displayed due to unit security"

This new domain user is an administrator in management reporter and has full rights to the report library.

Any ideas? this is pretty urgent to get their reports up and running.

Kevin

*This post is locked for comments

  • Suggested answer
    kjjson Profile Picture
    kjjson on at
    RE: Management Reporter data mart access - domain change

    Thanks Richard, I actually found the answer. They had setup a user security group and had assigned it in a few of the reporting trees, so those particular reports where requiring the user to be added to those security groups in order to view the reports run based off of those trees. All is well.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Management Reporter data mart access - domain change

    Are you saying you have a new server that is a member of two domains or  this new server is a member of only the new domain?

    https://support.microsoft.com/en-us/help/3163587/after-you-make-changes-to-your-domain-you-no-longer-have-permission-to

    These tips may be of help. All the security is kept within the ManagementReporter database. The users are kept in there with their domain credentials so you will not be able to simply copy over the databases. It may be best to simply export the building blocks from the old server, install MR onto the new server and import those building blocks. You would need to add the users to the new MR instance.

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans