Link to home
Start Free TrialLog in
Avatar of Wayne Barron
Wayne BarronFlag for United States of America

asked on

Windows 2016 Server Core - Add node to a SQL Server Failover Cluster (cmd Code Supplied - Almost Working)

Hello, All.

OK, 2016 Server CORE.
Added node to SQL server 2019 Failover Cluster.


I found this page, Install SQL Server NODE from the Command Prompt which is helpful. However, I am not able to complete the installation without error.
This is code I wrote, with the help of the link above.

.\Setup.exe /QS /Action=AddNode /IACCEPTSQLSERVERLICENSETERMS=true          
/INSTANCENAME=SQLInstanceNameHere /FAILOVERCLUSTERNETWORKNAME=ClusterNameHere  
/FAILOVERCLUSTERIPADDRESSES=192.168.2.36 /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM"  
/CONFIRMIPDEPENDENCYCHANGE=0 /AGTSVCACCOUNT=DomainNameHere.local\sqlagent  
/AGTSVCPASSWORD=******* /SQLSVCACCOUNT=*******

Open in new window


This is the error I receive when it is "Running Rules for Feature Installation"

The following error occurred:
You have selected a feature that is not supported for Windows Server Core.
The supported features on Windows Server Core are: Database Engine Services,
SQL Server Replication, Full-Text and Semantix Extractions for Search, Analysis Services,
Client Tools Connectivity, Integration Services, and SQL Client Connectivity SDK.

Error result: -2067922334
Result facility code: 1214
Result error code: 61

I found this on the error above. However, it is for 2012, not 2019
You cannot install a SQL Server 2012 Cluster Instance

I went through the installation process on a test server, to see what Features it picks up on, during the installation. And on the
Cluster Node Configuration - Page.
Features = SQLEngine, SQLEngine\Replication, SQLEngine\FullText, SQLEngine\DQ

Open in new window


It has the features being installed that Core requires, and nothing more.
So, why is it yelling >> You have selected a feature that is not supported for Windows Server Core ???


Any assistance on installing/Adding node to a Failover cluster.
Please let me know.

Wayne
Avatar of lcohan
lcohan
Flag of Canada image

Before getting into the SQL Server installation as it is not clear from the details you posted above - do you actually have already a Windows cluster with WFCS already configured and tested as described here https://docs.microsoft.com/en-us/windows-server/failover-clustering/create-failover-cluster ?
Avatar of Wayne Barron

ASKER

Second line  
>> Add node to SQL server 2019 Failover Cluster.
Once I did that, I was then given the option to add a node.

I am getting ready to update my TA
TA has been updated.
Please review the new details.
(Also updated the Add Node, to Added Node. To make it clearer that this has been completed)
Someone on the SQL Server Forum posted that SQLEngine\DQ is not allowed in a core --- However, I had read that it is allowed.
However, I have uninstalled it from the instance and will test out tomorrow on rather I am able to install it.
But for now, I am going to bed.
ASKER CERTIFIED SOLUTION
Avatar of Wayne Barron
Wayne Barron
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial