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 five Virtual Machines (VMs) on which you need to
install Microsoft SQL Server 2012 database. This should have two network adapters, one configured
for public and one configured 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 configured for public and one
configured for private.
•Server for the Quorum folder – This is the third of the four VMs and is needed to create the Quorum
•WDM Server – This is the fourth VM on which you need to install WDM.
Pre-requisites for Database Clustering
Database clustering requires the following :
• 4 VMware Virtual Machines (VMs) out of which 2 VMs should contain 2 network adapters each.
• Supported version of Microsoft SQL Server Database (standalone version). For more information on
supported databases, see Support Information.
• All the VMs should be connected to an Active Directory (AD) domain.
• All the four VMs should have Windows Server 2008 R2 installed on them.
NOTE: You cannot use SQL Server Express for database clustering.
Configuring the Primary and Secondary VMs
After you create the VMs on the server, you must configure them to support clustering. You must
configure both the primary and the secondary nodes by following the steps given below.
To configure the primary and secondary VMs
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
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.
8. Make sure that the Public Network option is first in order in the Advanced Settings window.
9. To launch the Advanced Settings window, select the Advanced Settings option from the Advanced
menu in the Network Connections screen.
10. In the Network Connections screen, select the Public, right click and select Properties.
11. In the Advanced Settings window, select IPv4 and click Properties.