Motivation: Making the Systems Engineers life easier.

Blog

SQL Failover Cluster Installation

Microsoft SQL

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

Leave your thought here

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Archives