Web Application Requirements (Master Data Services)

Master Data Manager is a web application hosted by Internet Information Services (IIS). Master Data Manager works best when viewed in Internet Explorer (IE) 7 or later; IE 6 is not supported. InPrivate Browsing will only work if SQL Server 2012 SP1 is installed. For best results:

  • In IE 8 or 9, turn off the compatibility view.

  • In IE 10 or 11, turn on the compatibility view.

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.

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).

Requirements

Operating System

The following Windows operating systems include the Internet Information Services (IIS) functionality required for the Master Data Services web application and web service.

SQL Server 2012 Developer (64-bit) x64

SQL Server 2012 Enterprise (64-bit) x64

SQL Server 2012 Business Intelligence (64-bit) x64

  • Windows Vista Business, Enterprise, and Ultimate

  • Windows Server 2008 SP2

  • Windows Server 2008 R2 SP1

  • Windows 7 Professional, Enterprise, and Ultimate

  • Windows 8 Professional, Enterprise, and Ultimate

  • Windows Server 2008 SP2

  • Windows Server 2008 R2 SP1

  • Windows Server 2012

  • Windows Server 2008 SP2

  • Windows Server 2008 R2 SP1

  • Windows Server 2012

For a full list of the Windows operating systems that are supported for your edition of SQL Server, see Hardware and Software Requirements for Installing SQL Server 2012.

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 (Windows Server 2008 or Windows Server 2008 R2, Windows Vista, Windows 7 operating systems)

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

Note

On Windows Vista and Windows 7 operating systems, use Programs and Features in Control Panel to enable these options in the Windows Features dialog box.

Web Server

   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

Role and Role Services (Windows Server 2012 or Windows 8 operating systems)

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

Note

On the Windows 8 operating system, use Programs and Features in Control Panel to enable these options in the Windows Features dialog box.

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

   Performance

      Static Content Compression

   Security

      Request Filtering

      Windows Authentication

Features (Windows Server 2008 or Windows Server 2008 R2, Windows Vista, Windows 7 operating systems)

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

Note

On Windows Vista and Windows 7 operating systems, use Programs and Features in Control Panel to enable these options in the Windows Features dialog box.

.NET Framework 3.0 Features

   WCF Activation

      HTTP Activation

      Non-HTTP Activation

Windows Process Activation Service

   Process Model

   .NET Environment

   Configuration APIs

Features (Windows Server 2012 or Windows 8 operating systems)

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

Note

On the Windows 8 operating system, use Programs and Features in Control Panel to enable these options in the Windows Features dialog box.

.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

Accounts and Permissions

Type

Description

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).

The application pool account needs the VIEW SERVER STATE permission, to avoid server errors. For example, the MDS Validate Version command fails with a server error. For more information, see MDS Validate Version command fails with a server error in SQL Server 2012 and SQL Server 2014

See Also

Tasks

Create a Master Data Manager Web Application (Master Data Services)

Concepts

Install Master Data Services

Web Configuration Page (Master Data Services Configuration Manager)