Microsoft distributes Microsoft SQL Server 2012 fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2012 fix release.
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.
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:
Download the cumulative updates into a local folder or UNC path. For example, download the cumulative update to the following folder:
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:
Open a command prompt as an administrator, and then run the following command:
Setup.exe /action=installfailovercluster /updatesource=<Folder path of update EXE>
Complete the setup wizard typically. To do this, follow these steps:
Click OK to set up support rules
On the Product Updates page, verify that the hotfix package exists, and then click Next.
On the Install Setup Files page, click Install.
On the following pages, click Next:
Setup Support Rules
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.
On the following pages, click Next:
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:
The fix for this issue was first released in Cumulative Update 1 for SQL Server 20012. For more information about how to obtain this cumulative update package for SQL Server, click the following article number to view the article in the Microsoft Knowledge Base:
Note Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server fix release. We recommend that you consider applying the most recent fix release that contains this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
2692828 The SQL Server 2012 builds that were released after SQL Server 2012 was released
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
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:
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.
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 problems
For 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 packages
For 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