Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics SL (Archived)

How do I change the management reporter administrator?

(0) ShareShare
ReportReport
Posted on by

I am having all kinds of issues with the installation and configuration of Management Reporter.  I hope someone can help me.

Originally when I defined our server it was not a domain controller.  Since then I have made it a domain controller but SQL users got screwed up.  I think I have all of that resolved now.  So I started the management reporter installation and configuration process.  I started an incident with a tech a few weeks ago and he had me create a new user to access MR.  But I had issues with that when I tried to get into Dynamics.   So I would like to change the administrator for MR to a different user but can't seem to figure out how to do it. 

I went to SQL, security, Made sure the user was there, made sure the user had rights to the dynamics databases and management reporter databases.   What else do I need to do?  When I go into MR configuration console I get the error, You don't have permission to access companies in Management Reporter.  And Unable to connect to the application service to retrieve configured ERP integrations.

Any ideas?

*This post is locked for comments

  • Community Member Profile Picture
    on at
    RE: How do I change the management reporter administrator?

    HI good Info.

    What if you can;t get logged in with a "working administrator" how can you reset via the DB?

  • JoshP Profile Picture
    on at
    RE: How do I change the management reporter administrator?

    Hello Ann!

    If you are getting the error "You don't have permission to access companies in Management Reporter" when running the Configuration Console, this is because the domain user you are logged in as is not added to the Management Reporter Security as an Administrator user. Note that when adding a user, it adds more than just the user ID, it adds details about the account. If all of the details of this account do not match (beyond just the domain\username), the user is not considered as a MR user. This is likely what happened

    My suggestion for you is to:

    1. Create a backup of your MR database.

    2. Login to the MR Report Designer as a working Administrator user.

    3. Go to the Security tab.

    4. Locate the user who is getting the "You do not have permission..." error, right-click the user and select Delete.

    5. Go to File | New | User.

    6. Search for the user you just deleted and re-add him/her.

    7. Verify that the newly added user can successfully run the Report Designer and Configuration Console.

    Thanks!

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March 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... 294,261 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,996 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans