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.
Before you install Master Data Services, review the following requirements:
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.
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.
|Internet Information Services|
Web Management Tools
IIS Management Console
World Wide Web Services
.NET Extensibility 3.5
.NET Extensibility 4.5
Common HTTP Features
[Note: Do not install WebDAV Publishing]
Health and Diagnostics
Static Content Compression
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
HTTP Activation [Note: This is required.]
TCP Port Sharing
Windows Process Activation Service
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.
|Windows account||You 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 account||When 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)