web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / management reporter 20...
Microsoft Dynamics AX (Archived)

management reporter 2012 configuration error

(0) ShareShare
ReportReport
Posted on by ewills 5,990

I am trying to configure AX 2012 legacy and provided the following information 

Port: 8201

Server: SERVER

Username: SERVER\Administrator

 

The Administrator is a the AD domain admin and also have ERP AX user with Sys Admin role.  

In the SQL database, against "DynamicsAX" database he has sysadmin permission 

For some reason i couldn't see the dbreader but public permission (eventhough i select the dbreader)

 

Microsoft.Dynamics.Performance.Reporting.Common.ReportingPermissionException: You don't have permission to perform this operation.

   at Microsoft.Dynamics.Performance.Reporting.Security.Service.SecureServiceBase.SecureExecuteInternal[TResult](Func`1 hasPermission, Func`1 executor)

   at Microsoft.Dynamics.Performance.Reporting.Common.Service.ServiceBase.BaseExecute[TResult](Func`1 executor)

Component: Microsoft.Dynamics.Performance.Reporting.DataAccess.Server.CompanyService

User: SERVER\Administrator

*This post is locked for comments

I have the same question (0)
  • ewills Profile Picture
    ewills 5,990 on at

    Any thought from experts here in this forum?

  • ninzer Profile Picture
    ninzer 650 on at

    i am having similar issue as well.  Have you found any solution?

  • Community Member Profile Picture
    Community Member on at

    It is possible that the user account might have been disabled in MR database.

    Run following query on MR database and check if account exists and not disabled.

    'select * from SecurityUser'

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    'select * from SecurityUser'

    I had the same issue. I changed SecurityUser.RoleType from a 2 to a 5 because the installer had a RoleType of 5 and the other users had a RoleType of 2. Maybe it is because our MS Reporter is using windows credentials and our Dynamics server is using SQL server credentials. I don't have a clue why, but it works.

  • Farhan Syed Profile Picture
    Farhan Syed 1,156 on at

    I am facing the same issue with User 2 with RoleType 5 ( the same as the administrator). The user is able to log into Ax, but the moment I try loading MR it fails. When I try assigning the user to the group for a company access this what happens "Access can't be granted to the specified integrated company. Company access is assigned in the source system." Am I missing anything ?

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Andrew Jones a1x Profile Picture

Andrew Jones a1x 2

#3
GL-01081504-0 Profile Picture

GL-01081504-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans