How to setup virtual SQL 2012 cluster on windows 2012R2 VM using SCVMM2012R2 Part-2

Post windows cluster validation describe in part1, prerequisite like  .Net3.5 feature must be installed on all the SQL server. Other than it will be normal windows fail over cluster and then start SQL setup as follows.

 

It will check for necessary support files and then validated it by running test

Next it will check for the latest update , uncheck it and click next

This will check install file post which it will run the validation for setup support rules

Setup rules will finish with some warning which can be ignored

Now this will ask for product key and if this has already downloaded with key then it will appear

For my Citrix XenDesktop deployment I just need following feature

Feature rules will test for cluster support

Here I am using  network name as CitrixSQL. It does not accept special character

Next it will check validate the space

Don’t worry about qualified as red . I spend lots of time figuring that out but next will explain why it was . So hit next here

Once hit next make sure select both the cluster disk. If you recall in my previous post, I did mention why labeling of disk is mandatory. This was the reason. Update the message with correct reference.

This cluster IP is for SQL cluster node name.

I usually run SQL service using specific account

Next we have server config  where I specify SA password

On the same option Data Directories tab is important. This will insure that database and logs stored separately. After changing click on next.

I don’t want to do error reporting to MS so I hit next where it check for cluster installation rules.

With this we are ready to install and keep our finger crossed

For me SQL installation finish with the following error message

I followed article and manually created  the cluster resource under AD and then gave full control to windows cluster name. Post which all the resource came online.

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” .

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

The operation Change properties of virtual machine is not permitted on a virtual machine that has shared virtual hard disks

I was trying to remove the shared virtual hard drive from the VM

and it was failing with error

Error (23317)

The operation Change properties of virtual machine is not permitted on a virtual machine that has shared virtual hard disks.

Recommended Action

The operation Change properties of virtual machine is not permitted on a virtual machine that has shared virtual hard disks

First try removing harddisk but when it ask save the config cancel and click on generate script

Script will come with many lines but focus on this

Add force to the line

Source

How to upgrade rollup pack for HyperV host?

While we  upgraded SCVMM 2012 R2  server and console for rollup pack 1 but couldn’t find a way to upgrade Hyper V host and it was complaining Warning (20510)

An upgrade is available for Virtual Machine Manager agent version 3.2.7510.0 on the computer XXX.COM.

Recommended Action

Update the VMM agent, and then try the operation again.

To find out the status select the host and then choose view status.

Once we choose host agent version and select repair all . This will fix all the remaining host in the cluster.

Integrate Honeywell Barcode Scanner with XD 7.1 and Wyse T10 thinclient

This post to showcase barcode scanner integration with XD 7.1. Here I am using barcode scanner from Honeywell and exact model is

Now to start with we need to configure StoreFront for legacy site. Once legacy site is setup we need to configure Wyse T10 which runs WTOS (Wyse Thin OS)  for legacy site. To configure legacy site on T10 we need to configure remote connection and then choose Citrix Xen where we need to supply PNA legacy site address as http://<URL _of_SF_/CITRIX/STORE/PNAgent/Config.xml >

Once this information is supplied it will prompt for reboot post which it will provide login screen.

Once logged in it will present a desktop where Hosted shared desktop can be launched

While testing barcode scanner ,we used XD 7.1 VDA running over Windows 2008 R2. Please check this video and sorry about bad visual.