Master Data Services (MDS)–Overview & Installation- Part1


Master Data Services, also known as MDS, is one of the key business intelligence features being introduced with SQL Server 2008 R2. The basic goal of Master Data Services is to provide a single authoritative source for information within your enterprise.This information can then be used by other applications and databases so that every application in your environment is always looking at a single authoritative copy of the same information.In this series I will introduce this feature to you and I will share with you our industry standards , my practices and my experience in this area.

Before you can use Master Data Services, you need to install it. This requires a 64-bit server because the MDS installer in only available in a 64-bit build. Yet , I dedicate this post to the installation for SQL Server 2008 R2 Master Data Services .


Software Requirements

Operating Systems

Supported 64 bit operating systems include:

  • Windows Server 2008
  • Windows Server 2008 R2
  • Windows 7 Professional
  • Windows 7 Enterprise
  • Windows 7 Ultimate
  • Windows Vista Business
  • Windows Vista Enterprise
  • Windows Vista Ultimate
SQL Server

Supported 64 bit SQL Server editions include:

  • SQL Server 2008 R2 Data Center
  • SQL Server 2008 R2 Enterprise
  • SQL Server 2008 R2 Developer
.NET Framework

Master Data Services requires .NET Framework 3.5 SP1 or later. If you do not already have .NET Framework 3.5 SP1 installed on your computer, Setup will install it before installing the Master Data Services components and tools.


If PowerShell 1.0 or above is not installed on the operating system, MDS Configuration Manager will not be able to perform all operations.

Internet Information Services (IIS)

If IIS7 or above is not installed on your computer, the Web Configuration selection will be disabled in Configuration Manager.

Required Web Service (IIS) role and role services

Master Data Services requires installation of the Web Server (IIS) role and the following IIS role services:

Common HTTP Features
  • Static Content
  • Default Document
  • Directory Browsing
  • HTTP Errors
Application Development
  • ASP.Net
  • .NET Extensibility
  • ISAPI Extensions
  • ISAPI Filters
Health and Diagnostics
  • HTTP Logging
  • Request Monitor
  • Windows Authentication
  • Request Filtering
  • Static Content Compression
Management Tools
  • IIS Management Console
Required features

Master Data Services requires installation of the following features on the host server:

.NET Framework 3.0 Features
  • WCF Activation
  • HTTP Activation
  • Non-HTTP Activation
Windows PowerShell
Windows Process Activation Service
  • Process Model
  • NET Environment
  • Configuration APIs

Installation Process

Navigate to the MasterDataServices.msi located in the 1033_enu_lpx64setup directory and double click on the file to start the installation and follow the installation wizard per the below screen shots.


Click Run


Click Next to continue


Review the license Agreement and Click Next to continue


Enter Name and Company

And then Click Next to continue


Define the installation path and Click Next to continue


Click install to start the installation




Click finish


Create and configure the Master Data Services database. .



Click on the Create Database button on the left side


Click Next to continue


Enter SQL Server Instance name , select your authentication type and type your user name and password


Type the Database Name


Enter the windows account that you will grant permission to the master data services database. this account will be used by the master data services web sites and web services to connect to the database.


Enter the account that you want to grant permission for administration


Click Next to continue



Click Finish to exit the wizard

  • Create and configure the Master Data Manager Web application. .

  • Associate the Master Data Services database and Master Data Manager Web application






Associate the Master Data Services database and Master Data Manager Web application