Every day I get many emails and blog comment with at least one new problem every day. Recently, one of my blog readers sent an email asking assistance. She already had two node Windows Cluster. Let us call them Node1 and Node2. SQL Server Clustered instance, was successfully installed on Node1. In SQL 2008 onwards, we need to run setup on Node2 and perform “AddNode” action by choosing below option.
While performing AddNode, there was a Rule Failure.
Rule Check Result
Rule “Node and cluster edition match” failed.
The edition of the new node does not match the edition of the cluster.
I asked to share the setup logs from Node2 and while looking at them, I found below.
2015-03-10 12:00:22 Slp: Initializing rule : Node and cluster edition match
2015-03-10 12:00:22 Slp: Rule applied features : ALL
2015-03-10 12:00:22 Slp: Rule is will be executed : True
2015-03-10 12:00:22 Slp: Init rule target object: Microsoft.SqlServer.Configuration.SetupExtension.AddNodeEditionBlock
2015-03-10 12:00:22 Slp: The edition user specified is: ENTERPRISE
2015-03-10 12:00:22 Slp: The edition of the cluster instance: STANDARD
2015-03-10 12:00:22 Slp: Evaluating rule : AddNodeEditionBlock
2015-03-10 12:00:22 Slp: Rule running on machine: Node2
2015-03-10 12:00:22 Slp: Rule evaluation done : Failed
2015-03-10 12:00:22 Slp: Rule evaluation message: The edition of the new node does not match the edition of the cluster.
If you closely look at the highlighted lines, you should be able to understand the issue. In case you didn’t understand – here is the issue.
SQL Server 2008 R2, which is installed is of Edition “Standard” edition (shown as an edition of clustered instance). The media, which were getting used while trying to perform AddNode operation was of “Enterprise” edition (shown as user specified).
Solution of the issue is very straight forward. She was supposed to use the media of the same edition, which was installed on Node1. Here is the screen where we can see edition of media.
The edition of the media is decided by the product key provided in the previous screen.
Reference: Pinal Dave (http://blog.sqlauthority.com)