Web Application Requirements (Master Data Services)


Published: March 25, 2016

Updated: July 7, 2016

Applies To: SQL Server 2016

Master Data Services is a web application hosted by Internet Information Services (IIS). Master Data Services works only in Internet Explorer (IE) 9 or later. IE 8 and earlier versions, Microsoft Edge and Chrome are not supported.

Use Master Data Services Configuration Manager to create and configure the Master Data Manager web application. Master Data Services Configuration Manager configures IIS on the local computer, so it is best for initial web configuration tasks. For example, configure a Master Data Services environment with a single Master Data Manager web application, or configure the first web application in a scale-out deployment of Master Data Services. Use IIS tools to perform more complex tasks, such as configuring multiple web servers in a scale-out deployment.

System_CAPS_ICON_note.jpg Note

Any computer on which you install components of Master Data Services must be licensed. For more information, refer to the End User License Agreement (EULA).

Operating System

Before you install Master Data Services, review the following requirements:

Microsoft Silverlight

To work in the Master Data Manager web application, Silverlight 5 must be installed on the client computer. If you do not have the required version of Silverlight, you will be prompted to install it when you navigate to an area of the web application that requires it. You can install Silverlight 5 from here.

Role and Role Services

On Windows Server 2012 or Windows Server 2012 R2, you can use Server Manager, which is available in the Microsoft Management Console (MMC), to install the Web Server (IIS) role, and required role services.

System_CAPS_ICON_important.jpg Important

Dynamic Content Compression is enabled by default. This significantly reduces the size of the xml response and saves the network I/O, though CPU usage is increased. For more information, see [CTP 2.0] Improved Performance in What's New in Master Data Services (MDS).

Internet Information Services

Web Management Tools

IIS Management Console

World Wide Web Services

Application Development

.NET Extensibility 3.5

.NET Extensibility 4.5



ISAPI Extensions

ISAPI Filters

Common HTTP Features

Default Document

Directory Browsing

HTTP Errors

Static Content

[Note: Do not install WebDAV Publishing]

Health and Diagnostics

HTTP Logging

Request Monitor


Static Content Compression


Request Filtering

Windows Authentication


On Windows Server 2012 and Windows Server 2012 R2, you can use Server Manager to install the following required features.

.NET Framework 3.5 (includes .NET 2.0 and 3.0)

.NET Framework 4.5 Advanced Services


WCF Services

HTTP Activation [Note: This is required.]

TCP Port Sharing

Windows Process Activation Service

Process Model

.NET Environment

Configuration APIs

Following is an example PowerShell script to add prerequisite server roles and features. The prerequisite server roles and features varies depending on the environment.

Install-WindowsFeature Web-Mgmt-Console, AS-NET-Framework, Web-Asp-Net, Web-Asp-Net45, Web-Default-Doc, Web-Dir-Browsing, Web-Http-Errors, Web-Static-Content, Web-Http-Logging, Web-Request-Monitor, Web-Stat-Compression, Web-Filtering, Web-Windows-Auth, NET-Framework-Core, WAS-Process-Model, WAS-NET-Environment, WAS-Config-APIs  
Install-WindowsFeature Web-App-Dev, NET-Framework-45-Features -IncludeAllSubFeature –Restart  

For more information about PowerShell command, see Install-WindowsFeature.

Accounts and Permissions

Windows accountYou must log on to the web server computer with a Windows account that has permission to configure Windows roles, role services, and features, and to create and manage application pools, web sites, and web applications in IIS on the local computer.
Service accountWhen you create the Master Data Manager web application in Master Data Services Configuration Manager, you must specify an identity for the application pool that the application runs in. This account can be different from the service account that was specified when the Master Data Services database was created.

This identity must be a domain user account, and it is added to the mds_exec database role in the Master Data Services database for database access. For more information, see Database Logins, Users, and Roles (Master Data Services). This account is also added to a Master Data Services Windows group, MDS_ServiceAccounts, which is granted permission to the temporary compilation directory, MDSTempDir, in the file system. For more information, see Folder and File Permissions (Master Data Services).

Install Master Data Services
Installing Master Data Services, and IIS Role and Features
Create a Master Data Manager Web Application (Master Data Services)
Web Configuration Page (Master Data Services Configuration Manager)

Community Additions