How to enable “Share file instead of Copying it “ for VMM

I came across many deployment and keep forgetting it how to enable “Share file instead of copying it ” option for VMM. Yes I know Microsoft Article explain how to do this but missing screenshot .

Provided that all the library share has been setup perfectly , when we try to share the ISO instead of mounting we get following error message

“Error (12700)
VMM cannot complete the host operation on the xyz.com server because of the error: 'xyz' failed to add device 'Virtual CD/DVD Disk'. (Virtual machine ID 86AF5EBE-0B3D-4075-8BF2-DA7117C54322)

'xyz': User account does not have permission required to open attachment '\\Mxyz\DataStore\ISO\XenApp_and_XenDesktop7_6.iso'. Error: 'General access denied error' (0x80070005). (Virtual machine ID 86AF5EBE-0B3D-4075-8BF2-DA7117C54322)
Unknown error (0x8001)

Recommended Action
Resolve the host issue and then try the operation again.”

We need to give access to VMM server for all the node. Select the Hyper V node and then choose “Use any authentication protocol” and add services.

Select VMM server as computer name. This will list CIFS share.

We need to repeat this step for all the node

Autoconfiguration IPv4 on Hyper V VM

I configured on hyperV VM on SCVMM2012R2 and it was not able to communicate over the LAN. When I checked network property it had Autoconfiguration IPv4 enabled with APIPA ( Automatic Private Internet Protocol Addressing ) .

Not sure what was causing it, tried googling but couldn’t find anything relevant. Checked for hidden nic but couldn’t find any. Finally changed IP address and that worked. Looks like above IP was somewhere on the network and this is enabling Autoconfiguration IPv4

Adding second node to the virtual SQL cluster 2012 on Windows 2012R2 using VMM–Part 3

In my previous  blog I explained how to install  the first node in this blog I will explain how to add the second node to the existing cluster.   Run the SQL setup and choose “Add node to a SQL Serverfailover cluster ”

This will run the check for prerequisite and validate it

 

Don’t run the check for updates and then exist the steps. It will run again SQL cluster install rule

Next it will check for product key and then license term. Post which it will identify SQL cluster node and will populate the info

Then it will validate the network for fail over cluster

Next it will pick  account for which you must retype the password

Then it will prompt for error reporting which you can choose as per wish. Click next and proceed further where it will check for node rules

It will give beautiful summary to add the node.

Finally installation of SQL second node will be done

Finally node has been added and here is the summary

Thanks for reading my blog, today I configured DDC on fail over cluster

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