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.

PowerShell

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
Security
  • Windows Authentication
  • Request Filtering
Performance
  • 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_lp\x64\setup directory and double click on the file to start the installation and follow the installation wizard per the below screen shots.

1

Click Run

2

Click Next to continue

3

Review the license Agreement and Click Next to continue

4

Enter Name and Company

And then Click Next to continue

5

Define the installation path and Click Next to continue

6

Click install to start the installation

7

8

9

Click finish

10

Create and configure the Master Data Services database. .

11

12

Click on the Create Database button on the left side

13

Click Next to continue

14

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

15

Type the Database Name

16

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.

17

Enter the account that you want to grant permission for administration

18

Click Next to continue

19

20

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

21

22

23

24

25

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

26

27