Changing System Administrator Account for Master Data Services–would need this after restoring MDS database to another instance of SQL Server

When you try to restore MDS database from one server to another server in a different domain where you don’t share same system administrator account, you will need to change the internal sys admin account for MDS database after the restore is done, so that you can connect to restored DB’s MDS UI.  This article…

1

Objects Overview in MDM database created by Master Data Services in SQL Server 2012 RC0

There are so many objects in MDM database that gets created when you create a model in Master Data Services.  Below outlines the significance of each object: Schema Name Type Of Object Object Name Sample Purpose/Comments Created or Used or Referenced in/by User defined process? Mdm Tables Mdm.tbl_N_N_XX These are internal system tables and should…

0