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.

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