Monday, July 1, 2013

Add Node to SQL Failover Cluster

Pre-requisites

  1. Windows 2008 Failover Cluster
  2. SQL 2008 Cluster on First Node
  3. VM with Windows 2008 R2 Enterprise
  4. 2 NICs on each VMs (1 for Public and 1 for Private)
  5. 4 IP Address for Public Range
  6. 2 IP Address for Private Range
  7. 2 Shared Disks (1 for Failover Cluster Quorum Disk and 1 for SQL Cluster Data Disk)

 Installation

Add Node to a SQL Server Failover Cluster


SQL 2008 R2 Failover Cluster Installation

Pre-requisites

  1. Windows 2008 Failover Cluster
  2. VM with Windows 2008 R2 Enterprise
  3. 2 NICs on each VMs (1 for Public and 1 for Private)
  4. 4 IP Address for Public Range
  5. 2 IP Address for Private Range
  6. 2 Shared Disks (1 for Failover Cluster Quorum Disk and 1 for SQL Cluster Data Disk)

 Installation

รจ The name you specify for the SQL Cluster it will add a DNS entry for the same so ensure it is unique
Select the Cluster disk which we added earlier
Provide the Public Range IP Address. Ensure it is unique as I have faced issue it doesn’t proceed it if its not unique
Specify the account to be used for the installation
Specify the installation directory . Ensure this is the Shared Disk which we created