You will notice when setting up MDS for the first time that it will use your AD account by default. This can become a problem if you leave a company and you are the System Administrator for MDS. When your AD account gets disabled by your workplace MDS will stop working, so best to set a service account as System Administrator on MDS.

A warning before you do this, once you have changed the System Administrator, the previous one’s account will be deleted off MDS.

Prerequisites:

  • You must first add the new administrator’s user name to the Master Data Manager Users list.
  • You must have permission to view mdm.tblUser and to execute the mdm.udpSecurityMemberProcessRebuildModel stored procedure in the Master Data Services database.

To change the administrator account:

  1. Open SQL Server Management Studio and connect to the Database Engine instance for your Master Data Services database.
  2. In mdm.tblUser, find the user that will be the new administrator and copy the value in the SID column.
  3. Create a new query.
  4. Type the following text, replacing DOMAIN\user_name with the new administrator’s user name and SID with the value you copied in step 2.
    • EXEC [mdm].[udpSecuritySetAdministrator] @UserName=’DOMAIN\user_name’, @SID = ‘SID’, @PromoteNonAdmin = 1
  5. Run the query.

After executing the query the new administrator will be in place and the previous administrators account will be removed.

Leave a Reply

Your email address will not be published. Required fields are marked *