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 .
Supported 64 bit operating systems include:
Supported 64 bit SQL Server editions include:
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.
If IIS7 or above is not installed on your computer, the Web Configuration selection will be disabled in Configuration Manager.
Master Data Services requires installation of the Web Server (IIS) role and the following IIS role services:
Master Data Services requires installation of the following features on the host server:
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.
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
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 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