Install Master Data Services

Previous Install SQL Internals Viewer	Manual Install	Install SQL Performance Dashboard Next

FineBuild can install and configure Master Data Services (MDS) as part of the SQL Server install process. If you do not want to include Master Data Services in your FineBuild install, then do not download it.

Master Data Services is written by Microsoft. It was chosen to be included in FineBuild because it provides a framework and repository for managing the key reference data of an organisation.

Item	Link
Master Data Services home page	https://docs.microsoft.com/en-us/sql/master-data-services/master-data-services-overview-mds
Master Data Services download	The latest version of MDS can be downloaded from the same KB reference used for a SQL Server Service Pack or Cumulative Update download
Master Data Services tutorial	https://www.red-gate.com/simple-talk/sql/database-delivery/master-data-services-basics/
Master Data Services video	https://www.youtube.com/watch?v=29VG1awCxkY

FineBuild Master Data Services Install

Automated silent installation of Master Data Services is performed by Process Id 4SF and is controlled by the parameters below:

SQL Version	Parameter	FULL Build	WORKSTATION Build	CLIENT Build
SQL2019	/SetupMDS:	No	No	N/A
SQL2017	/SetupMDS:	No	No	N/A
SQL2016	/SetupMDS:	No	No	N/A
SQL2014	/SetupMDS:	No	No	N/A
SQL2012	/SetupMDS:	No	No	N/A
SQL2008R2	/SetupMDS:	No	No	N/A
SQL2008	/SetupMDS:	N/A	N/A	N/A
SQL2005	/SetupMDS:	N/A	N/A	N/A

In order to maintain compatibility with older versions of SQL FineBuild, the parameter /InstMDS: can also be used.

SQL Version	Install Notes
SQL2012 or above	Master Data Services is included with the main SQL Server install, and therefore this section will be bypassed if you are installing SQL Server 2012 or above.
SQL2008 R2	Master Data Services is provided as an optional package for SQL 2008 R2. FineBuild can use the install media provided with SQL 2008 R2, or will use a more recent version if you download the MDS install file and place it in the Additional Components folder.
SQL2008 or below	MDS can not be installed for SQL 2008 or below

FineBuild will not by default install MDS, because most sites do not need this functionality.

If you want FineBuild to install MDS, then you must add the following parameter when you run FineBuild:

  /SetupMDS:Yes

Master Data Services can only be installed on x64 editions of SQL Server. If you install Master Data Services then FineBuild will also Install IIS.

Master Data Services must be configured manually after it is installed. For details see http://msdn.microsoft.com/en-us/library/ee633752.aspx.

Top

Manual Master Data Services Install

The manual install process is only required for installing MDS for SQL 2008 R2. MDS is installed as part of the SQL Server install for SQL 2012 or above.

Navigate to the relevant folder and double-click on the MDS install file:

Location Link

Original location \MasterDataServices\x64\1033_ENU\MasterDataServices.msi

Download location \Additional Components\MasterDataServices.msi
The Welcome window is displayed

Click Next to continue
The License Agreement window is displayed

Accept the license and click Next to continue
The Registration Information window is displayed

Complete the registration details and click Next to continue
The Feature Selection window is displayed

Click Next to continue
The Ready to Install window is displayed

Click Install to continue
The Installing MDS window is displayed

Wait until this window closes
The Completion window is displayed

Click Finish to end