Wayne Barron
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.
This is the error I receive when it is "Running Rules for Feature Installation"
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.
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
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=*******
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
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
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 ?
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
>> 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
ASKER
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)
Please review the new details.
(Also updated the Add Node, to Added Node. To make it clearer that this has been completed)
ASKER
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.