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

Notifications

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) / Master Data Management
Microsoft Dynamics AX (Archived)

Master Data Management

(0) ShareShare
ReportReport
Posted on by Martina Bergamo 1,470

Hi to all!

When I try to publish an entity to SQL Master Data Services I receive the following error:

Error: OperationResult
Context: N/A
Error 120002: The user does not have permission to perform this operation.


On the Database, the user axadmin has the following roles: db_owner, public, mds_exec.

Any ideas?

Thanks

Martina

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Tommy Skaue Profile Picture
    Tommy Skaue Moderator on at

    Hi Martina

    Please have a look at the outlined security considerations included in this blog post:

    https://blogs.msdn.microsoft.com/daxserver/2014/07/28/security-configuration-in-ax-2012-mdm/

    Security Configuration
    MDM requires multiple security settings to work correctly, ensure that the following user accounts have correct privileges.

    AOS service account permission for Data Import/Export service
    The AOS service account that runs import/export must be part of Data Import/Export Framework Users local group. If you get a security exception when validating DIXF, it is mostly likely that AOS user (usually Network Service) is not part of the group. Make sure that you add AOS user to the group in Computer Management. Restart AOS.

    Verify: Open Data import/export framework > Setup > Data import/export framework parameters, and then click Validate. 
    If the connection is configured correctly, the box will turn green.

    Grant the DIXF service account permission to the SQL Server Master Data Services web service and database

    Master Data Services Web Application

    The Data import/export service account must be configured to have function permissions in Master Data Services so that it can push and pull data and create schemas. To enable these permissions, perform the following procedure: 
    1. Open the Master Data Services web application.
    2. Click Users and Group Permissions.
    3. Add the DIXF service account user.
    4. Select the DIXF service account user.
    5. Click Functions.
    6. Click Edit.
    7. Assign the following functions:

    • System Administration
    • Version Management
    • Integration Management
    • Explorer

    Best Practices: In a production environment with all entities configured, we recommend that you remove the functions from the service account, and instead assign specific model permissions for reading and writing data to models.

    • Assign Update permissions for each model in environments in which you both pull and push data.
    • Assign Read-only permissions for each model in environment in which you only pull data.

    Verify: Log in with the DIXF service account on the local machine, and open the Master Data Services web application and verify that the user has access.

    Master Data Services SQL Server database
    Assign the following database roles to the DIXF service account in the Master Data Services database:

    • MDM_Exec
    • MDS_Exec
    • DB_DataReader
    • DB_DataWriter
    • DB_DDLAdmin

    Verify: Connect to the Master Data Services database using SQL Server Management Studio and the DIXF service account to validate database connectivity.

  • Martina Bergamo Profile Picture
    Martina Bergamo 1,470 on at

    I've done all this things. But it does not work...

  • Tommy Skaue Profile Picture
    Tommy Skaue Moderator on at

    So when doing each of the three validations to verify permissions, you're getting the expected results?

  • Martina Bergamo Profile Picture
    Martina Bergamo 1,470 on at

    Yes...I followed all the steps. It seems to be all ok!

    But the "Publish entity" give me the error...

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans