Export (0) Print
Expand All
1 out of 1 rated this helpful - Rate this topic

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.

Caution noteCaution

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

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.