Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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.

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

Cumulative update information

SQL Server 2012

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:

2679368 Cumulative update 1 for SQL Server 2012Note 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

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

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×