Install Master Data Services
The following workflow provides an overview of how to install and configure Master Data Services. Master Data Services installation is a three-part process:
Pre-Installation Tasks: Verify system requirements before you install Master Data Services.
Installation Operations: Install Master Data Services by using SQL Server Setup or the command prompt.
Post-Installation Tasks: Open Master Data Services Configuration Manager to complete post-installation operations. Create and configure the Master Data Services database, Master Data Manager web application, and web services, and deploy a sample model.
Pre-Installation Tasks
Action |
Details |
Related Topics |
|---|---|---|
Verify installation requirements |
The computer where you run SQL Server Setup must meet minimum requirements for:
You can separate the web server computer and database server computer by running Setup on only the web server computer and creating the Master Data Services database on a remote computer that runs a supported version and edition of SQL Server. |
Features Supported by the Editions of SQL Server 2012 Hardware and Software Requirements for Installing SQL Server 2012 |
Configure the required roles, role services, and features |
Before you run Setup, configure the computer with the required Windows roles, role services, and features. Note Although you can perform this step later in the workflow, it is helpful to configure this prior to running Setup so that you can perform web configuration tasks immediately following the installation. |
|
Review language support considerations |
Determine the language that you want to install and run Master Data Services in. |
Installation Operations
Action |
Details |
Related Topics |
|---|---|---|
Run SQL Server Setup |
On the computer that will host the Master Data Manager web application and Master Data Services web services, use SQL Server Setup or a command prompt to install Master Data Services. When you use SQL Server Setup, Master Data Services is available on the Feature Selection page under Shared Features. When you use a command prompt, Master Data Services is available as a feature parameter. Note that the command-line setup process installs Master Data Services, but does not configure it. You must configure it using the Master Data Services Configuration Manager. The installation process:
|
Install SQL Server 2012 from the Installation Wizard (Setup) |
Master Data Services in a Cluster
Starting with SQL Server 2012 Cumulative Update 1 (CU1), Master Data Services is supported as part of a SQL Server clustered instance installation. Master Data Services in SQL Server 2012 supports installation only in a cluster scenario without any instance of SQL Server previously installed on the cluster node. For more information, see here.
Post-Installation Tasks
Action |
Details |
Related Topics |
|---|---|---|
Open Master Data Services Configuration Manager to complete post-installation operations |
After Setup completes, open Master Data Services Configuration Manager. Master Data Services Configuration Manager performs the following post-installation operations on the local computer:
If you script the installation process, you can open Master Data Services Configuration Manager to register the Master Data Services snap-in, but you must manually perform the other steps to complete the configuration. Master Data Services Configuration Manager provides you with a wizard-driven configuration process. There is no command-line process for configuring Master Data Services. |
|
Create a Master Data Services database |
Use Master Data Services Configuration Manager to create a Master Data Services database for your master data. |
|
Create a Master Data Manager web application |
Use Master Data Services Configuration Manager to create and configure a web application to host Master Data Manager. |
Create a Master Data Manager Web Application (Master Data Services) |
Associate a Master Data Services database with a web application |
Use Master Data Services Configuration Manager to associate your Master Data Manager web application with your Master Data Services database. |
Associate a Master Data Services Database and Web Application |
Configure Internet Explorer Enhanced Security |
When you install Master Data Services on a Windows Server 2008 or Windows Server 2008 R2 computer, you might have to configure Internet Explorer Enhanced Security to allow scripting for the Master Data Manager application site. Otherwise, browsing to the Master Data Manager application site on the server computer will fail. |
|
Install the Master Data Services Add-in for Excel |
Users who will work with master data can install the Add-in for Excel. |
|
Enable Data Quality Services (DQS) integration |
For users of the Master Data Services Add-in for Excel, enable integration with the DQS feature, which can be used to match similar data. |
Enable Data Quality Services Integration with Master Data Services |
Deploy a sample model |
Sample model packages are installed with Master Data Services, and can be deployed using MDSModelDeploy.exe. |
If you encounter issues during the installation process or initial configuration, see Troubleshooting Installation and Configuration Issues on TechNet Wiki.
If you no longer need Master Data Services on a computer, you can uninstall Master Data Services and determine whether to remove items that are not affected by the uninstall process. For more information, see Uninstall and Remove Master Data Services.