Web Application Requirements (Master Data Services)
Applies to: SQL Server (all supported versions) - Windows only Azure SQL Managed Instance
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.
For instructions on how to install and configure IIS, see Installing and Configuring IIS.
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.
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).
Before you install Master Data Services, review the following requirements:
- Hardware and Software Requirements for Installing SQL Server 2016 and 2017
- Hardware and Software Requirements for Installing SQL Server 2019
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.
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
- ASP.NET 3.5
- ASP.NET 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
- ASP.NET 4.5
- WCF Services
- HTTP Activation [Note: This is required.]
- TCP Port Sharing
- Windows Process Activation Service
- Process Model
- .NET Environment
- Configuration APIs
- Dynamic Content Compression
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 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. 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).