locked
Adding MDS 2012 to an existing cluster instance RRS feed

  • Question

  • We have an Active/Passive clustered SQL server instance. It was originally installed as SQL 2008 R2. We did an in place upgrade to SQL 2012 SP1.

    We did not install MDS services in the original install. When we attempt to add MDS it fails with the following error:

    Rule “Existing clustered or clustered-prepared instance” failed

    Is there a way to install MDS to the existing instance?

    I seem to read conflicting information about the possibility. One entry said this was resolved in CU1, but that doesn't seem to be the case. I've also read that you can add a new node to the cluster that does contain MDS. Finally, I read that you can bypass the cluster rule check to force the installation:

    Setup.exe /SkipRules=StandaloneInstall_HasClusteredOrPreparedInstanceCheck /Action=Install

    Can anyone offer any guidance in how to add this feature? Or are we stuck re-building the cluster if we want MDS in the same instance?

    Thanks in advance!

    Shawn

    Thursday, January 30, 2014 3:34 PM

Answers

  • Shawn,

    Issue is well known by MS support.

    The issue is related to RMT media installation for SQL Server 2012. Recommendations are as follows:

    -        Downloaded SQL Server 2012 SP1 slipstream media,

    -        Install SQL 2012 using the SP1 slipstream. To do this we need to open a command prompt, change directory to the location of the setup.exe for the original SQL 2012 install media, and run the following command:

    setup.exe /action=install /updatesource=”<LocationOfSP1InstallMedia>”

    -        Follow the installation wizard, and make sure to choose “Perform a new installation of SQL Server 2012” option in the Installation Type dialog since MDS is a shared component and that’s all we’re installing.

    -        Select only to install the “Master Data Services” shared feature.

    -        Accept all the rest of the defaults to complete installation.

    I hope this helps!

    Sincerely, The Happy DBA!


    Wednesday, February 12, 2014 6:58 PM