Install SQLServer2016 Failover Cluster in Windows 2016

This article mainly describes how to deploy SQLServer2016 Failover Cluster in Windows Server 2016, and what is Failover Cluster, see the Microsoft technical documentation.

Deployment environment

numbering	Server name	IP Address	Operating System
001	AD1	192.168.100.250	Windows Server Datacenter Evaluation
002	Storage	192.168.100.252	Windows Server Datacenter Evaluation
003	SQL1	192.168.100.242	Windows Server Datacenter Evaluation
004	SQL2	192.168.100.243	Windows Server Datacenter Evaluation
005	Csql	192.168.100.244	SQL Server Cluster
006	MSSQL	192.168.100.245	SQL Server Service

Prerequisite Settings

1. Configure the ad domain controller, how to configure the ad domain controller, see Create AD Domain
2, deploy storage, how to configure storage See Deployment Storage
3. Set IP address, DNS pointing to domain controller IP
4, install users here to use the domain administrator, or create a new domain user, you need to have domain administrator rights, to have the domain, Active Directory in the computers this directory to create the permissions of the computer, and have SQL1 and SQL2 in the local Super Admins group permissions.

SQL1:
IP address:192.168.100.242
netmask:255.255.255.0
gateway:192.168.100.1
dns:192.168.100.250

SQL2:
ip:192.168.100.243
netmask:255.255.255.0
gateway:192.168.100.1
dns:192.168.100.250

4, set the computer name, join the contoso.com domain

Configuration Store

On the storage server, you need to create two iSCSI virtual disks for use by SQL Server cluster
Open "Server Manager" and click "File and Storage Services"

Go to file and storage services, point to iSCSI, select Tasks-new iSCSI virtual Disk

Run the new iSCSI Virtual Disk Wizard, configure "iSCSI Virtual Disk Location" to be f, and click "Next"

Specify the iSCSI virtual disk name and click "Next"

Specify the iSCSI virtual disk size and click "Next"

To assign an iSCSI target, select "New iSCSI Target" and click "Next"

Set the iSCSI target name and click "Next"

Set the access server, click "Add", select the method used to identify the initiator select "Enter a value of the selected type", the type is "IP address", the value is "192.168.100.242", click "OK"

Add a value for the "192.168.100.243" IP address type and click "OK"

Access server settings OK, click "Next"

Enable authentication Service Here, just point to "next."

Confirm the configuration and click "Create"

Create complete, click "Close"

Create a new quorum witness, still inside iSCSI, point to "task"-"new iSCSI Virtual Disk"

Run the new iSCSI Virtual Disk Wizard, set the iSCSI virtual Disk location, select on the F drive, and click "Next"

Set the iSCSI virtual disk name and click "Next"

Set the iSCSI virtual disk size and click "Next"

iSCSI Target Select "existing iSCSI target", Target name Select "mssql192", click "Next"

Confirm the configuration and click "Create"

Create complete, click "Close"

Then the storage is set.

Connect Storage Configuration Disks

Connect storage configuration disks Both the SQL1 server and the SQL Server need to be connected to the storage, and the SQL1 server configuration is the same as the SQL2 server configuration.
Open Server Manager on the SQL1 server, click Tools-iSCSI Initiator

Tip "The Microsoft iSCSI service is not running yet, to make iSCSI work, you must start the service ..." and click "Yes"

Open the ISCSI Initiator property, enter the IP address of the storage server "192.168.100.252" in the "Target" field, click "Quick Connect", then see the target status of the discovery show "Connected", then click "Finish", then click "Finish", so the connection storage is completed

Right-click "Start" of the SQL1 server and click "Disk Management"

Open Disk Management, right-click the connected Disk 1 point "online"

Right-click the connected Disk 2 point "online"

Right-click on disk 1, click "Initialize Disk"

Initialize the disk, select "Disk 1" and "Disk 2", click "OK"

Right-click on "Disk 1"-"New Simple volume"

Set Volume size

Set Drive disk

Setting up a formatted partition

Complete the new simple volume

Right-click on "Disk 1"-"New Simple volume"

Set Volume size

Set Drive disk

Setting up a formatted partition

Complete the new simple volume

Configure Disk Completion

Install roles

Install roles SQL1 server configuration and SQL2 server configuration, the operation is as follows.

On the SQL1 server, open Server Manager, click "Add Roles and Features", install type Select "Role-based or feature-based installation", click "Next"

Server Select the server in the server pool, click "Next"

Server role Click "Next"

Function Select "Failover Cluster" and click "Next"

Confirm configuration, click "Install"

The role installation is complete, click "Close"

Configuring a Failover Cluster

Open Server Manager on the SQL1 server, point to Tools-failover Cluster Manager, or click Start-Windows Management Tools-failover Cluster Manager to open Failover Cluster Manager (fail-over).

After you open failover Cluster Manager, we first "verify the Configuration"

Open the Validate a configuration wizard and click Next

Select the server or cluster, click "Browse", select the computer, check the name after entering the object name, click "OK"

Select Server to complete, click "Next"

Test Options Select "Run All tests (recommended)" and click "Next"

Confirm, click "Next"

Verification complete, click "Done"

When the verification is complete, click "Create Cluster"

Open the Create Cluster wizard and click Next

Select the server or cluster, click "Browse", select the computer, enter the object name, click "Check Name", click "OK"

Server select Complete, click "Next"

Access points for administering the cluster, enter the cluster name and the cluster address, and click Next

Confirm the configuration and click "Next"

The cluster has been successfully created, click "Finish"

Expand Cluster, point "node", you can see SQL1 and SQL2 two nodes

Then expand Storage, point "disk", you can see two disks, a piece of available storage, a disk witness in a quorum, so the cluster is created

New SQL Server failover cluster installation

Download the SQL Server ISO Setup program on SQL1, load it, go to the installer directory, double-click "Setup.exe", open the SQL Server installation Center

In the SQL Server Installation Center, click Install-"New SQL Server failover cluster Installation"

Open Install SQL Server failover cluster, select the "Evaluation" version, and click "Next"

License Terms, tick "I accept the License terms" and click "Next"

Global rule validation passed, click "Next"

Since the SQL Server installation package is up-to-date, it is not updated here, save time and click "Next"

Product updates, click "Next"

Install the failover cluster rule validation by clicking "Next"

Install SQL Server feature Select your desired tick and click "Next"

Instance configuration, enter "SQL Server network Name" and click "Next"

You can see the disks in the failover cluster in the cluster resource group and click "Next"

Cluster disk selection, where "cluster Disk 1" is automatically selected, click "Next"

Cluster network configuration, configure the cluster IP address, click "Next"

Specify the service account and click "Next"

Specify the collation, select as needed, click Customize, select SQL Collation ..., and click OK

Click "Next"

Specify database Engine authentication security mode, administrator

Specify the data directory and click "Next"

Reporting Service configuration default is OK, click "Next"

Function configuration Rule Verification pass, click "Next"

Confirm configuration, click "Install"

When the installation is complete, click "Close"

To add a node to a SQL Server failover cluster

Download the SQL Server ISO Setup program on SQL2, load it, go to the installer directory, double-click "Setup.exe", open the SQL Server installation Center

In the SQL Server Installation Center, click Install-Add a node to a SQL Server failover cluster

Open the Add Failover Cluster Node Wizard, where you select the "Evaluation" version and click "Next"

License Terms, tick "I accept the License terms" and click "Next"

Global rule validation passed, click "Next"

Since the SQL Server installation package is up-to-date, it is not updated here, save time and click "Next"

Product updates, click "Next"

Add Node rule validation pass, click "Next"

Cluster node configuration, click "Next"

Cluster network configuration, click "Next"

Service account configuration, click "Next"

function rule verification complete, click "Next"

Ready to add node OK, click "Install"

Node add complete, click "Close"

Verify that the SQL Server service is successful

Now we can see the "Failover Cluster Manager"-"role" in which the owner node is "SQL1"

Right-click on "SQL Server"-"mobile"-"Best Node"

At this point we can see that the owner node is "SQL2" and verify that the SQL Server service succeeded

Installing SQL Server Administration Tools

Now back on the SQL1 server, the SQL Server 2016 installation package does not have the SQL Server administration Tools, all you need to download, install separately, double-click "Ssms-setup-16.0-chs.exe", Run "Microsoft SQL Server Management Studio ", click" Install "

is installing

When the SQL Server Administration Tools installation is complete, click "Close"

Point "Start"-"Microsoft SQL Server"-"Microsoft SQL Server Managerment Studio"

Open Microsoft SQL Server Managerment Studio, the server name has been automatically entered with the name of the SQL Server network you just created, click "Connect"

Cluster SQL Server login succeeded

Install SQLServer2016 Failover Cluster in Windows 2016