SQL Failover Cluster Installation

Assuming that you have two (2) SQL Failover Cluster Node Servers and you need to add more instances on it.

1. SQL Server 2012 Installation Media mounted on both the SQL Server nodes
2. Database and Logs VHDX/VHD mounted on the SQL Server and added in the Failover Cluster Manager Disks
3. Be ready with the Instance Name and Instance IP Address

Let’s start with installation.

1. Mount the SQL Server disk on the VM and run the Setup file as Domain Administrator and Click on New SQL Server failover cluster installation link
2. Setup Support Rules wizard should run successfully then click Ok, you can click on Show Details to View
3. Setup Support Rules wizard should run successfully then click Next
4. Product Key will be taken by default if you are using a licensed copy, click Next
5. Accept the license terms and click Next
6. Select the Instance Features as shown below and click Next
7. Once Features Rules successfully completes, click Next
8. Enter the SQL Server Instance Name as shown below and click Next
9. SQL Server cluster resource group name will be shown be default based on the Instance Name, click Next
10. Select DB and Logs disk which we had mounted on the SQL Server in the first stage and click Next
11. Disk Space Requirements and Disk Usage Summary, click Next
12. Assign an IP for the Instance and click Next
13. Assign Account Name and Password for SQL Server Agent and SQL Server Database Engine and click Next
14. Select Windows Authentication Mode, then add respective users under Specify SQL Server administrators who can manage the Instance, click on Data Directories and aasign the appropriate path for DB and Logs click Next
15. Click Next on the Error Reporting window, you can check mark if you want to send error reports to Microsoft
16. Click Next when Cluster Installation Rules checkup is completed successfully
17. Click Install
18. Click Close which the installation is completed successfully

Add node to a SQL Server failover cluster

1. Mount the SQL Server disk on the VM and run the Setup file as Domain Administrator and Click on Add node to a SQL Server failover cluster link
2. Setup Support Rules wizard should run successfully then click Ok, you can click on Show Details to View
3. Setup might check for any Product Updates, click Next to proceed
4. Setup Support Rules wizard should run successfully then click Next
5. Product Key will be taken by default if you are using a licensed copy, click Next
6. Accept the license terms and click Next
7. Select the Sql Server instance name which we had created and click Next
8. Cluster IP will be taken by default, click Next
9. Enter the password for Account Name and click Next
10. Click Next on the Error Reporting window, you can check mark if you want to send error reports to Microsoft
11. Click Next when Add Node Rules checkup is completed successfully
12. Click Install
13. Click Close which the installation is completed successfully