Install a SQL Server failover cluster instance
To create a new SQL Server installation for the failover cluster, sign in to Node 1 using the domain Administrator credentials, and start the SQL Server Installer executable. This starts the SQL Server Installation Center.
The following steps provide an outline of this installation. Refer to the Microsoft documentation (https://msdn.microsoft.com/en-us/library/ms179530.aspx) for more detailed information.
-
On the Installation page, click New SQL Server failover cluster installation.
The Install a SQL Server Failover Cluster window appears.
-
On the Product Key page, indicate whether you are installing a free edition of SQL Server, or whether you have a PID key for a production version of the product. Click Next.
-
On the License Terms page, read the license agreement, and then select the check box to accept the license terms and conditions. Click Next.
-
The Global Rules checker runs a discovery operation on your computer.
The Global Rules checker verifies the system state of your computer before setup continues.
If the checker identifies any missing product updates, on the Product Updates page, select the Include SQL Server product updates check box and click Next to continue.
-
The setup checker identifies potential problems that might occur while running setup. You must correct failures before setup. Click Next to continue.
-
On the Feature Selection page, select Database Engine Services.
Sub-features are automatically selected.
Click Next.
The setup runs another set of rules that are based on the features you selected to validate your configuration.
-
On the Instance Configuration page, do the following:
-
Specify a network name for the new SQL Server failover cluster. This is the name that is used to identify your failover cluster on the network.
-
Specify a named instance, name it for example SQLCLUSTER.
-
Click Next.
-
-
On the Cluster Resource Group page, you can specify the cluster resource group name where SQL Server virtual server resources will be located. Leave as default and click Next.
-
On the Cluster Disk Selection page, select the shared cluster disk resource for your SQL Server failover cluster.
The cluster disk is where the SQL Server data will be put. You can select more than one disk.
Click Next.
-
On the Cluster Network Configuration page, specify the network resources for your failover cluster instance.
Specify a static IP type and IP address for your failover cluster. This is recorded under Network in "Planning checklist".
Click Next to continue.
-
On the Server Configuration page under the Service Accounts tab, specify login accounts for SQL Server services. These are recorded under Service Accounts in "Planning checklist". Click Next to continue.
-
On the Database Engine Configuration page, define the following:
-
Under the Server Configuration tab, define the SQL Server administrator account and the server authentication mode.
-
Under the Data Directories tab, define the paths for the following. The path to where SQL Server data will be stored is recorded under Shared Storage in "Planning checklist".
-
Data Root Directory
-
User Database Directory
-
User Database Log Directory
-
Backup Directory Distribution can be, for example:
Disk Volume Usage Path 1 Cluster Quorum Drive N/A 2 1 Data Root Directory
User Database Directory
Backup Directory
F:\
F:\MSSQL13.SQLCLUSTER\MSSQL\Data
F:\MSSQL13.SQLCLUSTER\MSSQL\Backup
3 2 User Database Log Directory
TempDB data directory
TempDB log directory
E:\MSSQL13.SQLCLUSTER\MSSQL\Data Click Next.
The System Configuration Checker runs another set of rules that are based on the settings you selected to validate your configuration.
-
-
On the Ready to Install page, click Install.
-
After installation, the Complete page provides a link to the summary log file for the installation. Click Close to complete the SQL Server installation.