Answered by:

Combining standalone sql instance with Clustered instance

Question

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.

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

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

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 :)

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.

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.