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

Install Master Data Services

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.

Master Data Services home page http://msdn.microsoft.com/en-gb/sqlserver/ff943581.aspx
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 http://www.msdev.com/Directory/SeriesDescription.aspx?CourseId=155
Master Data Services Team blog http://sqlblog.com/blogs/mds_team/default.aspx
Master Data Services video http://www.sqlserver-training.com/master-data-services-mds-sql-server-2008-video-tutorial

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:

Install Parameter Build SQL2005 SQL2008 SQL2008 R2 SQL2012 SQL2014
SetupMDS FULL N/A N/A No No No
SetupMDS WORKSTATION N/A N/A No No No
SetupMDS CLIENT N/A N/A No No No

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 MDS will not be installed for SQL 2008
SQL2005 MDS will not be installed for SQL 2005

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.

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.

Original location \MasterDataServices\x64\1033_ENU\MasterDataServices.msi
Download location Additional Components\MasterDataServices.msi

2) The Welcome window is displayed. Click Next to continue.
MDS Welcome.png
3) The License Agreement window is displayed. Accept the license and click Next to continue.
MDS License.png
4) The Registration Information window is displayed. Complete the registration details and click Next to continue.
MDS Registration.png
5) The Feature Selection window is displayed. Click Next to continue.
MDS Feature.png
6) The Ready to Install window is displayed. Click Install to continue.
MDS Welcome.png
7) The Installing MDS window is displayed. Wait until this window closes.
MDS Progress.png
8) The Completion window is displayed. Click Finish to end.
MDS Complete.png
The manual install will immediately start the MDS Configuration process. For details see http://msdn.microsoft.com/en-us/library/ee633752.aspx.
Copyright © 2011 - 2014 Edward Vassie. License and Acknowledgements
Previous Install SQL Internals Viewer Top Install SQL Performance Dashboard Next

Last edited Apr 21, 2014 at 4:23 PM by EdVassie, version 11