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.
- 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:
- Open SQL Server Management Studio and connect to the Database Engine instance for your Master Data Services database.
- In mdm.tblUser, find the user that will be the new administrator and copy the value in the SID column.
- Create a new query.
- 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
- Run the query.
After executing the query the new administrator will be in place and the previous administrators account will be removed.