none
Combining standalone sql instance with Clustered instance

    Question

  • Hi 

    We have an existing SQL 2012 standalone instance installed on a single server. we want to install another instance on this server and we want this new instance to be a clustered SQL instance which makes the server one node of a 2-node cluster. we want to keep the standalone instance intact. 

    is this possible?


    MM

    Friday, June 28, 2013 7:21 AM

Answers

  • I think Its possible but make sure you keep standalone sql files on Local drive and Cluster files on Shared drive..risk is involved in you setup...I am not sure whether,when you will create OS cluster and sql cluster , this will effect your standalone installation...You have to install Cluster aware SQL instance as named instance assuming standalone instance is default one..

    Wait for others to comment on this


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


    Friday, June 28, 2013 7:40 AM

All replies

  • I think Its possible but make sure you keep standalone sql files on Local drive and Cluster files on Shared drive..risk is involved in you setup...I am not sure whether,when you will create OS cluster and sql cluster , this will effect your standalone installation...You have to install Cluster aware SQL instance as named instance assuming standalone instance is default one..

    Wait for others to comment on this


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


    Friday, June 28, 2013 7:40 AM
  • Hi 

    We have an existing SQL 2012 standalone instance installed on a single server. we want to install another instance on this server and we want this new instance to be a clustered SQL instance which makes the server one node of a 2-node cluster. we want to keep the standalone instance intact. 

    is this possible?


    MM

    Hello MAMK

    Just a question, are you planning on implementing AlwaysOn high availability? If so then SQL must not be installed as Clustered. If not, ignore :)

    regards

    Friday, June 28, 2013 10:56 AM
  • Possible, yes.  Supported, no.  Given the licensing costs of SQL Server, trying to save on hardware costs this way is not a cost-effective solution.  I would migrate the stand-alone instance to become a clustered instance. alongside the new clustered instance.

    Geoff N. Hiten Principal Consultant Microsoft SQL Server MVP

    Friday, June 28, 2013 3:39 PM
    Moderator
  • no we are not planning on implementing alwaysOn, we will implement passive/active cluster with shared resource. 

    we cannot migrate the installed instance to a clustered instance since it is the instance used by Lync which does not support clustering. 

    so it is not a supported setup?


    MM

    Monday, July 01, 2013 5:02 AM
  • Hello,

    What's the edition of the SQL Server instance ?

    Just as others post above, to install a SQL Server failover cluster, you must create and configure a  configure Windows Server Failover Clustering (WSFC). And then run the Setup program on each node of the failover cluster to install or add new node to a  SQL Server failover cluster. 

    If you want to configure two node failover clustering, you should install SQL Server standard edition or BI edition at least.

    Reference:http://msdn.microsoft.com/en-us/library/hh231721.aspx

    Regards,
    Fanny Liu


    Fanny Liu
    TechNet Community Support

    Thursday, July 04, 2013 9:19 AM
    Moderator