Change the 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:

• You must add the new administrator's user name to the Master Data Manager Users list. For more information, see Add a User (Master Data Services).

• You must have permission to view mdm.tblUser and to execute the mdm.udpSecurityMemberProcessRebuildModel stored procedure in the Master Data Services database. For more information, see Database Object Security (Master Data Services).

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.

See Also

Administrators (Master Data Services)