Combining standalone sql instance with Clustered instance

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 pos

June 28th, 2013 10:21am

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 o

Free Windows Admin Tool Kit Click here and download it now
June 28th, 2013 10:40am

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 pos

June 28th, 2013 1:56pm

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.
Free Windows Admin Tool Kit Click here and download it now
June 28th, 2013 6:39pm

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?

July 1st, 2013 8:02am

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

Free Windows Admin Tool Kit Click here and download it now
July 4th, 2013 5:22am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics