Install Guide

• Implementing a Node and File Share Majority Quorum
• Installing .NET Framework on Primary and Secondary Nodes
• Installing SQL server on primary and secondary Nodes
• Post Clustering Procedure
• Running the HA Conguration Utility
• Adding a License on WDM
Components Required for Database Clustering
The high availability environment for WDM consists of the following components:
• Primary Server or Primary Node – This is one of the four Virtual Machines (VMs) on which you need to install Microsoft SQL Server
2012 database. This should have two network adapters, one congured for public and one congured for private.
• Secondary Server or Secondary Node – This is the second VM and ensures high availability when the primary server fails. This should
also have two network adapters, one congured for public and one congured for private.
• Server for the Quorum folder – This is the third of the four VMs and is needed to create the Quorum folder
• WDM Server – This is the fourth VM on which you need to install WDM.
Pre-requisites for Database Clustering
Database Clustering requires the following :
• Four VMware Virtual Machines (VMs) out of which two VMs should contain two network adapters each.
• Supported version of Microsoft SQL Server Database (standalone version). For more information on supported databases, see Support
Information.
NOTE
: The steps for database clustering discussed in this guide are performed on Microsoft SQL Server 2012. However
database clustering is supported on other supported versions of SQL Server.
All the VMs should be connected to an Active Directory (AD) domain.
• All the four VMs should have Windows Server 2008 R2 Enterprise installed on them.
NOTE
: You cannot use SQL Server Express for database clustering.
Conguring the Primary and Secondary VMs
After you create the VMs on the server, you must congure them to support clustering. You must congure both the primary and the
secondary nodes by following the steps given below.
About this task
To congure the primary and secondary VMs
Steps
1 Launch the vSphere client on any system on the network and select the VM.
2 Right click and select Edit Settings. Click Add to add one more network adapter (also referred to as node).
3 In the Add Hardware screen, select Ethernet Adapter and click Next.
4 Select the Subnet from the Network label drop-down list and click Next.
5 Click Finish.
6 In the VM Properties screen, check that there are two nodes.
7 Launch the Network Connections screen from Control Panel → Network and Internet → Network Connections and rename the
network connections to
Private and Public.
NOTE
: There must be two subnets for two network cards i.e. one subnet for the Public network (PDB) and one subnet for
the Private network (PDB), and the same for the two network cards on the SDB server
8 Make sure that the Public Network option is rst in order in the Advanced Settings window.
64
Conguring High Availability database clustering for WDM