Thursday, February 13, 2014

Creating Microsoft virtual SQL cluster 2012 on SCVMM 2012 R2 Part-1

I wanted to setup Microsoft 2012 virtual cluster using SCVMM 2012R2. Current setup didn’t have option for  ISCSI lun so we have to either use passthrough  lun or use new feature of  windows 2012 R2 “ Shared the disk across the service tier” .

image

From the HyperV cluster option will looks like this

image

I couldn’t find option to create this using GUI. I followed PS command to create the disk and attached to the VM. For SQL fail over cluster , we need to setup windows cluster in such a way that disk are presented as available disk  and not as a CSV . We separated logs/Data and quorum disk. Now we need to create these 3 disk as shared disk.

image

Now make sure we attach this disk to both the SQL server which would be part of the cluster

image

Once these disk are attached it will showup under VM properties under VMM like this

image

Open diskmgmt.msc and scan for new disk. You will find all the disk. Disk should be initialize/format/assign drive letter and then offline. Once disk is offline

image

It is mandatory  that disk should be added in specific fashion with driver letter and stuff  like that or else SQL cluster validation will not go through. Rest of the cluster setup is same as normal but while running validation of cluster make sure that you uncheck option under storage “Validate Microsoft MPIO-based disks”

image

Until Cluster Validation is passed SQL cluster installation will not start

image

and it will throw error

image

Make sure NIC binding is set properly and domain NIC is first one in Advance network property . Here I am not dedicating separate NIC for HeartBeat

image

These clustered VM’s can not be storage motioned . To perform storage motion attached SCSI disk has be removed by following this post

image

In the next series I will explain how to install SQL and then how to add SQL node. This will be 3 blog set Smile Stay tune

No comments: