Share via


How to: Change the Master Data Services System Administrator Account (Master Data Services)

You can change the user account that is designated as the Master Data Services system administrator.

Warning

When you complete this procedure, the former system administrator user account is deleted.

Prerequisites

To perform this procedure:

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.