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” .
From the HyperV cluster option will looks like this
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.
Now make sure we attach this disk to both the SQL server which would be part of the cluster
Once these disk are attached it will showup under VM properties under VMM like this
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
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”
Until Cluster Validation is passed SQL cluster installation will not start
and it will throw error
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
These clustered VM’s can not be storage motioned . To perform storage motion attached SCSI disk has be removed by following this post
In the next series I will explain how to install SQL and then how to add SQL node. This will be 3 blog set 
Stay tune
Posts
