Installing a MS SQL 2016 failover cluster using the configuration file

A Microsoft SQL 2016 failover cluster can also be configured with the configuration file. This approach significantly speeds up the setting up of SQL FCIs by reducing the time for SQL setup and node configuration:

Before the installation, make sure that your infrastructure meets failover cluster requirements.

  1. Launch the SQL Server setup and choose the New SQL Server failover cluster installation option as shown in the following screenshot:

 New SQL Server failover cluster installatio

The Database Engine and Analysis Services are the only components that are cluster-aware. Other features are not cluster-aware and do not have high availability through failover.

  1. Proceed with the installation wizard and capture the configuration file. Save the captured configuration as sqlfciconfiguration.ini in c:\sqlconf.
  2. Navigate to SQL Server Source Media path and type the following:
Setup.exe /IAcceptSQLServerLicenseTerms=True /SQLSVCPASSWORD="P@ssw0rd1" 
/AGTSVCPASSWORD="P@ssw0rd1" /ASSVCPASSWORD="P@ssw0rd1"
 /ConfigurationFile=c:\sqlconf\sqlfciconfigurationfile.ini​
  1. Press Enter for the installation to start.

To enable SQL quiet installation modes, you need to open the configuration file and comment out the UIMODE parameter. Then add the switch /q for silent installation or /qs to show only the installation progress.

  1. On the additional SQL node, launch Add node to a SQL Server failover cluster, proceed with the wizard, and capture the configuration file. Save the captured file as sqlfcinodeconf.ini in c:\sqlconf:

 launch Add node to a SQL Server failover cluster

  1. Run the following command to add a node to the existing failover cluster:

    Setup.exe /IAcceptSQLServerLicenseTerms=True /SQLSVCPASSWORD="P@ssw0rd1" 
    /AGTSVCPASSWORD="P@ssw0rd1" /ASSVCPASSWORD="P@ssw0rd1" 
    /ConfigurationFile=c:\sqlconf\sqlfcinodeconf.ini​


  2. Repeat the previous step on all the additional nodes using the same configuration file.

Вас заинтересует / Intresting for you:

Introduction to the Family of ...
Introduction to the Family of ... 50 views Doctor Thu, 10 Oct 2019, 10:04:22
Introduction to SQL Server 201...
Introduction to SQL Server 201... 153 views Antoni Sat, 02 Mar 2019, 05:42:31
Automating the SQL Server Inst...
Automating the SQL Server Inst... 171 views Doctor Sun, 02 Dec 2018, 08:44:21
Automating Microsoft SQL Serve...
Automating Microsoft SQL Serve... 339 views Doctor Sun, 02 Dec 2018, 11:50:16

Comments on Installing a MS SQL 2016 failover cluster using the configuration file

Be the first to comment
Please login to comment