Need to install new instance on existing cluster in SQL 2014
I have an existing cluster with two nodes (A and B) having SQL instance INST1 running on window server 2012, I need to add more two nodes (C and D) and on that node I need new instance INST2 installed on same cluster, could any one just brief me the steps. I guess I need to add two nodes and then install new failover cluster on Node C and add Node D into that cluster.
Assuming I am following you correctly you want a single windows failover cluster with two current nodes to have four nodes but you want INST1 to only run on node A or B and INST2 to only run on nodes C and D? If this is correct I would have some follow-up questions on this topology. For example, I would be curious to know why you wouldn't want just two seperate two nodes windows failover clusters? Anyway, here are some high level steps. Here is high level steps. 1. Add node C and D to existing Windows Failover Cluster. 2. Adjust voting if needed. 3. Install SQL Server selecting New Failover Cluster on node C 4. Install SQL Server selecting Add Node to Failover Cluster for node D. 5. Under SQL resources make sure they could only run on nodes where SQL FCI has been configured.