Install on Node 1

Install SQL Server 2019 (TP) on Failover Cluster with Specific Configuration

  1. Run setup.exe from the SQL Server 2019 installation media to launch the SQL Server Installation Center.

    SQL Server SQL Server

  2. Click on the link New SQL Server failover cluster installation to launch the SQL Server 2019 setup Wizard.

    SQL Server SQL Server

  3. Keep the defaults and select Next. Since you are using the Evaluation edition, you do not need to enter a Product Key.

    SQL Server

  4. Read and accept the license terms. Click Next.

    SQL Server

  5. Check and validate global rules. Click Next.

  6. Choose to update Microsoft if needed and click Next.

  7. Confirm the Install Failover Cluster Rules. Click Next.

  8. Select Database Engine Services and Management Tools in the Feature Selection dialog. Click Next.

    SQL Server

  9. Confirm the Feature Rules. Click Next.

  10. Configure the instance:

    • SQL Server Network Name: sql-wsfc
    • Instance ID: MSSQLSERVER

  11. Check and accept the Cluster Resource Group. Click Next.

  12. Choose Cluster Disk in the Cluster Disk Selection dialog. Click Next.

  13. Configure Cluster Network Configuration:

    • Enter the virtual IP address: 10.10.1.18 for SQL Server. This depends on the IP address you added in the EC2 ENI.

  14. Click Next after entering the IP address.

  15. In the Server Configuration dialog:

    • SQL Server Agent: wsfc\sqlagent
    • SQL Server Database Engine: wsfc\sqlagent
    • Password: P@ssw0rd123!

  16. In the Database Engine Configuration dialog:

    • Choose Mixed Mode.
    • Add wsfc\sqlagent and wsfc\Admin to the SQL Server admin group.

  17. Configure data paths in the Data Directories tab.

  18. Confirm Feature Configuration Rules. Click Next.

SQL Server

  1. Confirm all configurations in the Ready to Install dialog and click Install.

SQL Server

  1. After the installation is complete, click Close in the Complete dialog.

SQL Server

  1. Access the Failover Cluster Manager:
    • Select Roles
    • Check that SQL Server is in the Running state and the Owner Node is node-01

SQL Server