3

I know Books Online says that standard edition only supports 2 nodes but how is this actually enforced?

Will it:

  1. Not let you install a new instance on a cluster with more than 2 nodes?
  2. Not let you add a 3rd node to a failover cluster that has at least 1 SQL Server standard edition instance?
  3. Not let you select more than 2 possible owners for the resource group / cluster role?

Or will it behave in some other way?

I'm curious because one of the admins would like to expand an existing cluster from 2 nodes to 3 nodes but it has 2 standard edition instances of SQL Server on it so I don't know what will happen.

  • Is this SQL Server 2008 R2? – Max Vernon Jan 27 '17 at 15:48
  • @MaxVernon the cluster has SQL 2008 R2 and SQL 2012 instances running on Windows 2008 R2 – Alf47 Jan 27 '17 at 16:02
1

I have just tried to do this very thing with SQL 2012 on Server 2012.

I created a 4-node cluster (Windows 2012 does not impose the 2-node limit), installed a SQL role on the first two nodes, however during the setup process of adding the third node, you get an error message in the checklist with a message informing you that the Standard edition of SQL server does not allow more than 2 nodes for a SQL role.

Setup will not allow you to proceed past this point, so now I find myself a) wishing I'd had more time to read up on the edition limitations and b) with a much beefier 2-node cluster instead!

So, to directly answer your question, number 2 is correct, 1 and 3 are perfectly allowable.

1

Of course licensing is a necessary part of Microsoft's business, so it is not surprising that the installation would enforce the limits that the purchaser is granted.

Setting up a SQL Server Failover cluster for SQL Server 2012 (Standard as well as Enterprise editions) you must first:

Create a New SQL Server Failover Cluster (Setup)

Option 1: Integration Installation with Add Node (i.e. only 2 nodes permitted.)

  1. Create and configure a single-node SQL Server failover cluster instance. ...
  2. On each node to be added to the SQL Server failover cluster, run Setup with Add Node functionality to add that node.

Option 2: Advanced/Enterprise Installation

Add or Remove Nodes in a SQL Server Failover Cluster (Setup)

This option continues on to link to other pages that provide more detailed installation instructions for Advanced/Enterprise Installations. The warning is not explicitly called out for these installations.

This suggests that (1) the Add or Remove Nodes process and (2) the license or, if you prefer, the Standard edition, provides the tools to protect both the purchaser and the provider by controlling, in this case, how many failover nodes can be installed.


Looking forward to SQL Server 2016 SP1 which will bring some good benefits on Standard Edition, by allowing many features to run on Standard. But it will not allow for multi-node SQL Server failover cluster installations.

Clarification: For SQL Server Standard Edition (from 2000-2016) the failover cluster can only support 2 nodes per instance. If you are using SQL Server Enterprise Edition you can support more nodes both synchronous and asynchronous, the exact numbers depending on the release you are using.

True, it is also possible to install another instance of SQL Server, even a failover cluster, but it would not be part of the first cluster. And if this was installed on the same physical server, there would likely be some resource contention.

If you want a Third Server in your landscape you can install another server and implement log shipping from the active Cluster Node to the Third Server. Since this has some latency issues the Third Server will not always be fully up-to-date with the data being shipped to it.

  • "But it will not allow for multi-node SQL Server failover cluster installations"... Can you elaborate on this? Does this mean that if my cluster has more than 2 nodes I can currently installed a SQL 2012 standard edition instance on two of the nodes but as of SQL 2016 SP1 I cannot? – Alf47 Feb 8 '17 at 18:13
  • @Alf47 - Added comments at the end of the post – RLF Feb 8 '17 at 21:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.