SQL Server 2012 AlwaysOn Availability Group Environmental Setup

Continuing from AlwaysOn Part 1 the series continues with a step-by-step guide to setting up the environment for an AlwaysOn availability group.
In this article we will break down AlwaysOn environment preparation into three steps :

  1. Installation of SQL Server 2012 on each node/replica/server.
  2. Installation of the failover clustering feature on each node/replica/server.
  3. Creation of a failover cluster and joining all nodes/replicas/servers to the cluster.

Installation of SQL Server 2012 on Each Node/Replica

You need to install SQL Server 2012 on each node/replica/instance that you want to include in an availability group. Click on New SQL Server stand-alone installation or Add feature to an existing installation link on the SQL Server Installation Center screen as shown below (please note, even though the availability group feature is based on WSFC, you will need to do a standard installation of SQL Server, not the one which is used for SQL Server failover clustering by clicking on the second link New SQL Server failover cluster installation or third link Add node to a SQL Server failover cluster in the screenshot below :

Note that even though AlwaysOn availability group is based on Windows Server Failover Cluster, it is still not the same as traditional SQL Server failover clustering and so we need to do a stand-alone installation as opposed to a failover cluster installation.

Installating Failover Clustering on Each Node/Replica

You also need to install Failover Clustering feature of the Operating System on each node/replica by using Initial Configuration Tasks or Server Manager. Open Server Manager (Start -> Administrative Tools -> Server Manager), click Features on the left under Server Manager node and then under Features Summary, click the Add Features link as shown below:

In the Add Features Wizard, check Failover Clustering as shown below and then click Next button to forward in the installation process (if this feature is already installed you can skip this step):

On the Confirmation Installation Selections page of the Add Features Wizard, click the Install button as shown below to start the installation of selected feature:

As previously noted, you will need to repeat this process (installation of failover cluster feature) on all the nodes/servers/replicas that you want to be part of AlwaysOn availability group. Installation of the failover cluster feature does not create a cluster but instead installs the necessary parts.

Also note that the failover clustering feature is only available with the Enterprise and Datacenter editions of the OS and not with Standard and Web editions.

Create a Failover Cluster and Join All Nodes/Replicas To The Cluster

Once you have installed failover clustering feature on each of the nodes/servers, you can now create a Windows failover cluster and include these nodes to this cluster. Open Failover Cluster Manager (Start -> Administrative Tools -> Failover Cluster Manager), and click Create a Cluster link as shown below:

As indicated in the Create Cluster Wizard you need to be local administrators on each of the servers/nodes which you want to be part of the cluster. It’s highly recommended to run the validation test for your configuration to ensure that hardware and hardware settings are compatible for Windows failover clustering or cluster creation. Click Next continue with the installation:

On the Select Servers page of the Create Cluster Wizard, you need to add all your servers/nodes to the the Windows Failover Cluster and the click Next to continue, in this example I have two servers/nodes (ARSHAD-PC and ARSHAD-LP):

On the Validation Warning page of the Create Cluster Wizard, you can validate the hardware and hardware configurations of all the servers involved including network and storage. It’s highly recommended that you perform a validation test before you actually create a windows failover cluster although it is not mandatory.

Description: Description: Description: cid:image004.png@01CCCF09.881A6BF0

On the next screen you need to provide name of your Windows Failover Cluster that as shown below, in my case I have used AlwaysOnDemo as the name:

The next screen is basically a confirmation or review page where you can review your selections/inputs provided during the wizard, if everything looks fine, click Next to start creating the cluster:

Windows failover cluster creation and configuration may take some time, the next screen shows a progress bar and some information on the installation:

The final screen of the wizard shows the final results of Windows failover cluster creation and configuration, you can click on View Report to see the report or click Finish to close the Create Cluster Wizard:

Im the next article we will look at creating and configuring the Availability Group



Related Articles :

One Response to “SQL Server 2012 AlwaysOn Availability Group Environmental Setup”

  1. It is recommended to have more than 2 windows server on AG cluster? The traditional SQL 2005/2008 clustering have been requiring 3 windows server to form a quorum. Just wondering if AG would recommend the same.

    Thanks,
    Simon

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |