News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Management Reporter - ...

Finance | Project Operations, Human Resources, ...

Unanswered

Management Reporter - Domain Controller Change

(0) Share

Report

Report

Posted on by Sunil Chhabra

1,938

We recently changed the domain controller. We would like to retire the old Domain controller.

But when the old Domain Controller is turned off the user is not able to connect to Management Reporter. Everything else works except connecting to MR.

The user's local Windows SID is different then the user's window SID in Management Reporter>Reporting.Security User Table

S-1-5-21-200548818-1768717461-3373405391-5130 Local user workstation
S-1-5-21-200548818-1768717461-3373405391-5133 MR Reporter

Would this be the cause? If this is cause would updating the MR table to same SID as the local workstation work?

Thanks

Categories:

Microsoft Dynamics GP

All responses Img

All responses (1)

Answers Img

Answers (0)

Greg Byer 2,586 on at

Like (0)

Report

RE: Management Reporter - Domain Controller Change

MR uses the SID so once you turn off the old DC, that SID is not available for MR. You'll want to use the steps in the KB article below to update the SecurityUser table in the MR database with the new SID.

support.microsoft.com/.../after-you-make-changes-to-your-domain-you-no-longer-have-permission-to-access-management-reporter-ba6dd1c4-bc33-3093-e626-2c0c7f776c91

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 231,321 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans