KB2683467 - FIX: Master Data Services is not supported on a clustered installation of SQL Server 2012

Symptoms

Consider the following scenario. You run the Microsoft SQL Server 2012 setup to install a failover cluster that has the Master Data Services (MDS) feature enabled on a computer. Then, you try to add a node in the cluster. In this scenario, although the node is added successfully, the MDS binaries are missing from the added node in the cluster, and the start menu icons are missing on the added nodes. Additionally, the MDS feature is installed incorrectly on the added node.

Resolution

To resolve this issue, install the following cumulative update. This cumulative update enables support for MDS as part of a clustered SQL Server 2012 setup. Master Data Services in SQL Server 2012 supports installation only in a cluster scenario, 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. To enable support, use one of the following methods:

• If the failover cluster is already installed and the MDS feature is missing from added cluster nodes, the SQL Server 2012 installation has to be uninstalled and then reinstalled on those nodes by using the steps that are described later in this article. Before you uninstall the SQL Server 2012 clustered instance, make sure that you create backups of any user databases.

• If you do not have an instance of SQL Server 2012 installed, you should still follow the steps that are described later in this article in order to perform the installation and to apply cumulative update package 1. Then, the cumulative update package will be included when you perform a fresh setup on the cluster.
  
  Note When you run the SQL Server 2012 setup, you will be promoted to the "Scan for Product Updates" step. However, you can find and download only Microsoft General Distribution Release (GDR) and service pack updates. Cumulative update package 1 is not listed. 
  
  To include cumulative update package 1, you can use the command line to point to the downloaded package for the latest update. To do this, follow these steps:

  1. Download the cumulative updates into a local folder or UNC path. For example, download the cumulative update to the following folder:

     C:\CU1Update

  2. Use one of the following methods to run an .ini file to point the SQL Server 2012 Setup program to the folder in which the cumulative update package is saved:
     

     • To install SQL Server 2012 with the MDS feature on the primary cluster node, follow these steps:

       1. Open a command prompt as an administrator, and then run the following command:

          Setup.exe /action=installfailovercluster /updatesource=<Folder path of update EXE>For example, run the following command:

          setup.exe /action=installfailovercluster /updatesource=c:\CU1Update

       2. Complete the setup wizard. To do this, follow these steps:

          1. Click OK to set up support rules.

          2. On the Product Updates page, verify that the hotfix package exists, and then click Next.

          3. On the Install Setup Files page, click Install.

          4. On the following pages, click Next:

             • Setup Support Rules

             • Product Key

             • License Terms

             • Setup Role

          5. Select Database Engine Services and Master Data Services, and then click Next.

          6. On the Feature Rules page, click Next.

          7. On the Instance Configuration page, type the SQL Server network name for the failover cluster, and then click Next.

          8. Click Next on the Disk Space Requirement page.

          9. On the Cluster Resource Group page, type the name of the SQL Server cluster resource group to which the failover cluster resources will be added, and then click Next.

          10. On the Cluster Disk Selection page, select a disk, and then click Next.

          11. On the Cluster Network Configuration page, check the network settings, and then click Next.

          12. On the Service Configuration page, enter service accounts information, and then click Next.

          13. On the following pages, click Next:

              • Error Reporting

              • Cluster Installation Rules

              • Ready to Install

     • To install SQL Server 2012 with the MDS feature on an additional cluster node, follow these steps:

       1. Open a command prompt as an administrator from a new server, and then run the following command:

          Setup.exe /ACTION=ADDNODE /UPDATESOURCE=<Folder path of update EXE> For example, run the following command:

          setup.exe /action=addnode /updatesource=c:\CU1Update

       2. Complete the setup wizard typically. To do this, follow these steps:

          1. Click OK to set up support rules

          2. On the Product Updates page, verify that the hotfix package exists, and then click Next.

          3. On the Install Setup Files page, click Install.

          4. On the following pages, click Next:

             • Setup Support Rules

             • Product Key

             • License Terms

          5. On the Cluster Node Configuration page, type the SQL Server network name from the primary cluster node installation (see step 2G under the preceding bullet point for the name of the instance of SQL Server), and then click Next.

          6. On the following pages, click Next:

             • Error Reporting

             • Add Node Rules

             • Ready to Add Node 

  For more information about product updates in the SQL Server 2012 installation, visit the following Microsoft Developer Network (MSDN) website:

  General information about product updates in the SQL Server 2012 installation

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

More Information

The clustering feature is included in AlwaysOn Failover Cluster instances that were released in SQL Server 2012.

For more information about AlwaysOn Failover Cluster instances, visit the following MSDN website: 

AlwaysOn Failover Cluster Instances

For more information about the Data Quality Services feature in SQL Server 2012, click the following article number to view the article in the Microsoft Knowledge Base:

2674817 FIX: The Data Quality Services feature is not supported on a SQL Server 2012 AlwaysOn failover cluster instance
Note The current Install Master Data Services page on MSDN and TechNet will be changed to reflect the fact starting with SQL Server 2012 Cumulative Update 1, 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.

References

For more information about the Incremental Servicing Model for SQL Server, click the following article number to view the article in the Microsoft Knowledge Base:

935897 An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problemsFor more information about the naming schema for SQL Server updates, click the following article number to view the article in the Microsoft Knowledge Base:

822499 Naming schema for Microsoft SQL Server software update packagesFor more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:

824684 Description of the standard terminology that is used to describe Microsoft software updates