SQL Server Failover Cluster Instance Setup

First we will install SQL Server on EC2SQL1

  1. Within the jump server, you can connect to EC2SQL1 by connecting to it using an RDP session:

  1. When asked for a user name and password, use the same credentials used to login the jumpserver: demosql\admin

  1. Open the Start menu and click on File Explorer

  1. Click on the (C:) drive and double click on SQLServer2019-x64-ENU-Dev ISO File

  1. Then double click on setup

  1. Select Installation and click on New SQL Server failover cluster installation

  1. For this Lab we will be using Developer Edition, click Next

  2. Microsoft Update, take default and click Next

  3. Install Failover Cluster Rules, the statuses should match below, if so click Next

  1. Feature Selection, click on Database Engine Services, three others will automatically be selected also, click Next

  1. Instance Configuration, enter SQL as the SQL Server Network Name, click Next

  1. Cluster Resource Group, accept the default SQL Server (MSSQLSERVER) and click Next

  2. Cluster Disk Selection, we wil not have any shared disks listed, click Next

  3. Cluster Network Configuration, we will be adding an IP to the 10.150.10.0/24 subnet, then click Next

    • 10.150.10.102

  1. Server Configuration, select the Grant Perform Volume Maintenance check box, enter the demosql\admin user and password provided by facilitator into the SQL Server Agent and SQL Server Database Engine areas, accept the other defaults and click Next

This Admin account being used for the service accounts is NOT recommended on any SQL install. This is a Lab configuration.

  1. Database Engine Configuration,

    • Select Server Configuration, then select Mixed Mode and enter the password provided by facilitator into the Enter and Confirm password areas. Click on Add Current User.

    * Select Data Directories, then enter the UNC paths for the Data and Log shares as shown below, the warnings can be ignored. * \\<DNS Name>.demosql.com\SQL-Data
    * \\<DNS Name>.demosql.com\SQL-Log
    * Select TempDB, remove the defaults for the Data and Log locations and replace with T:\Data as shown below, the warnings can be ignored. The T drive is an ephemeral drive and therefore more performant. * The remainder of the settings we will use the default, click Next

  2. Review the warning message regarding using a file server and click Yes

  3. Review the Summary and click Install

  4. Ensure all Feature Statuses report Succeeded and click Close

SQL Server is now installed on EC2SQL1

Now we will install SQL Server on EC2SQL2

We will repeat Steps 1-19 on EC2SQL2 with the following exceptions.

  • The install type will now be Add node to a SQL Server failover cluster
  • Cluster Network Configuration, we will be adding an IP to the 10.150.15.0/24 subnet.
    • 10.150.15.102
  • Review the Multi-subnet message and click Yes

SQL Server is now Installed