ManagementReporter - Database Restore to new Domain - MR Administrator Update

(0) Share

Report

Posted on by SL_GP_BC_123

1,090

We have a Dynamics GP customer that is building a backup/failover solution for their GP instance and is struggling a bit with Management Reporter. For MR normally we'll stand up a new instance and then just export and import reports from the main site.

But in this case the customer uses reporting groups and report library folders for distribution to various divisions/departments and would like to retain some of that framework if possible. We can successfully decrypt the MR database upon restore but are having issues in that the existing MR administrator is from the old domain. Has anyone successfully updated or remapped an existing MR Administrator after restoring a ManagementReporter database into a new domain, where the original Windows SIDs are no longer valid?

Please advise. Look forward to a response.

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Lisa at AonC.com 1,047 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
I have not done the exact migration you are describing but here are a few things that may help.

Cannot access Management Reporter after making changes to domain - Dynamics GP | Microsoft Learn - for information on modifying a SID in the Reporting.SecurityUser table.

How to move your Management Reporter 2012 database to a new server. - for possible steps/links to help. The comments have some additional tips.

In a few instances, I have recreated the MR database by importing the TDBX and then inserting data into the MR tables to recreate missing folders and groups. It has been several years since I last did it, but I remember it being fairly straightforward as the table names have some logic to them. 🙂

Was this reply helpful? Yes No