November 30, 2016 at 7:30 pm
Hi All,
We have one Active Passive cluster with SQL Server 2014 installed on it.
Is it possible to have another instance of 2014 on the same cluster and move the nodes?
Thank You.
Regards,
Raghavender Chavva
Thank You.
Regards,
Raghavender Chavva
December 1, 2016 at 8:33 am
It's not entirely clear what you're asking. Are you saying you want to add another node to the cluster with this new instance? That would require you're on SQL Server Enterprise Edition as Standard Edition only allows 2 nodes in a cluster.
Are you asking about installing a second instance on the same 2 node cluster but running on the node that's passive node of the first instance? That may have licensing implications as you then have an active-active scenario instead of active-passive.
Or are you asking about setting up a second instance on the same cluster but trying to keep it on the same active node as the first instance? Not sure if that's possible or not.
December 1, 2016 at 8:56 am
Chris Harshman (12/1/2016)
It's not entirely clear what you're asking. Are you saying you want to add another node to the cluster with this new instance? That would require you're on SQL Server Enterprise Edition as Standard Edition only allows 2 nodes in a cluster.Are you asking about installing a second instance on the same 2 node cluster but running on the node that's passive node of the first instance? That may have licensing implications as you then have an active-active scenario instead of active-passive.
Or are you asking about setting up a second instance on the same cluster but trying to keep it on the same active node as the first instance? Not sure if that's possible or not.
Sorry for the confusion.
My Question is about installing second instance on the same 2 node cluster.
If it is Active Passive cluster and already one instance installed. Now I want to install one more instance on the same cluster.
How can we proceed. All the possible ways.
Thank You.
Regards,
Raghavender Chavva
December 1, 2016 at 9:06 am
Yes, you can add a second instance. Install it the same way you did the first (although bear in mind there may be reboots and therefore you'll need to fail over the first instance a couple of times, so there'll be a brief interruption to service each time). As Chris hinted at, you need a separate licence for each node that SQL Server actually runs on (so both on the same node => one licence; each on a different node => two licences).
John
December 1, 2016 at 11:06 am
Adding to the comments and you may already know this - As far the shared storage for the cluster is concerned, you will obviously need new separate LUNS for your new Sql Server instance which will need to be prebuilt prior to the instance install. There are parts in the new instance install where you will pick the new storage locations for your files. You will also need a new IP address for the new instance also needed during the install.
December 6, 2016 at 9:42 am
Raghavender (11/30/2016)
Hi All,We have one Active Passive cluster with SQL Server 2014 installed on it.
Have you installed into a Failover Cluster Instance or is it a standalone instance to be used in an Availability Group, please be more specific
Raghavender (11/30/2016)
Is it possible to have another instance of 2014 on the same cluster
Yes it is, but again what do you8 have installed already and what is your intended usage, FCI and\or AG?
Raghavender (11/30/2016)
and move the nodes?
Move where, be more specific
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply