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.
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
You must log in to post a comment.