July 13, 2015 at 4:30 am
Hello Master,
We have one running SQL server 2008 Cluster, Is it possible to install SQL 2014 on the same cluster ? Would windows cluster will accept two different SQL version ? OR would SQL 2014 be allow to install SQL cluster on existing cluster ?
July 13, 2015 at 10:55 am
jitendra.padhiyar (7/13/2015)
Hello Master,We have one running SQL server 2008 Cluster, Is it possible to install SQL 2014 on the same cluster ? Would windows cluster will accept two different SQL version ? OR would SQL 2014 be allow to install SQL cluster on existing cluster ?
What version of windows are the cluster nodes running?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2015 at 4:07 am
Hello Perry,
Current cluster is with SQL server 2008 Enterprise Edition with latest service pack, OS is Windows server 2008.
Now we want to install SQL server 2014 on the same cluster. Is it possible ? We discuss lot internally, and it seems difficult, as we need to have one more SQL cluster name, IP and MSDTC service, so have no idea whether its possible.
July 14, 2015 at 5:57 am
jitendra.padhiyar (7/14/2015)
Hello Perry,Current cluster is with SQL server 2008 Enterprise Edition with latest service pack, OS is Windows server 2008.
Now we want to install SQL server 2014 on the same cluster. Is it possible ? We discuss lot internally, and it seems difficult, as we need to have one more SQL cluster name, IP and MSDTC service, so have no idea whether its possible.
Windows Server 2008 is a supported platform for SQL Server 2014.
You will require a separate IP address and networkname for the new instances Client Access Point and you will also require the provisioning of new shared storage for the new instance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2015 at 6:04 am
Bear in mind that it's not just a case of whether you can install it, but also whether you should, whether the server have spare capacity for the workload that the new databases will add to the server. Do you have spare memory for the new instance, is current CPU utilisation low enough that the workload from the new instance won't max out the server, etc, etc.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 14, 2015 at 6:27 am
Also think about how the original cluster design will behave if there is a failure?
How are you going to configure your resources per instance if its on a shared node?
Are you adding additional nodes to the cluster for this?
If remember correctly, SQL network name is one of the resources monitored on a cluster, if that goes offline, a fail-over is initiated. How will this affect the original design etc.?
Are you implementing an AlwaysOn solution? Then you wont need shared storage, just a network to be clustered.
July 21, 2015 at 3:43 am
Hello Masters,
Thanks a lot for the Suggestions !
After discussing all the possibilities, we decided to create new cluster instead of installing 2014 on existing 2008 cluster. Its fine for now, but I will try it on testing machine and will let you know what problems I will face during setup.
Thanks again !
Jitendra
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply