Install Master Data Services - SQL-FineBuild/Common GitHub Wiki

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.

  1. 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

  2. The Welcome window is displayed

    Click Next to continue

    ![Welcome](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/MasterDataServices/MDS Welcome.png)

  3. The License Agreement window is displayed

    Accept the license and click Next to continue

    ![License](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/MasterDataServices/MDS License.png)

  4. The Registration Information window is displayed

    Complete the registration details and click Next to continue

    ![Registration](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/MasterDataServices/MDS Registration.png)

  5. The Feature Selection window is displayed

    Click Next to continue

    ![Features](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/MasterDataServices/MDS Feature.png)

  6. The Ready to Install window is displayed

    Click Install to continue

    ![Ready to Install](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/MasterDataServices/MDS Ready.png)

  7. The Installing MDS window is displayed

    Wait until this window closes

    ![Progress](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/MasterDataServices/MDS Progress.png)

  8. The Completion window is displayed

    Click Finish to end

    ![Complete](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/MasterDataServices/MDS Complete.png)

The manual install will immediately start the MDS Configuration process. For details see https://msdn.microsoft.com/en-us/library/ee633752.aspx.

Copyright FineBuild Team © 2011 - 2021. License and Acknowledgements

Previous Install SQL Internals Viewer Top Install SQL Performance Dashboard Next