windows failover cluster

The mount point disk volume is not a clustered resource.To continue, add the resource to the cluster, or remove the mount point to cluster the shared disk

I had a Windows 2012 cluster on which my SQL team was trying to create a new role and install SQL 2016 on it. When running through the SQL installation they kept getting an error message and the base disk which acts as a mount point for the rest of the disks wasn't being detected and an error would show up.

The way we install SQL is,  we have a base disk which acts as a mount point, which is generally 1 Gb in size. Then we have different disks namely Data,Backup,Logs and TempDB which are mounted inside this base disk as mount points and have varying sizes depending upon the requirement. The actual error was:

"The mount point disk volume '\\?\Volume{79d2349d-08dc-472a-ba6a-a73117f88bd2}\' mounted at 'J:\$RECYCLE.BIN\S-1-5-21-1831736574-1690769945-617630493-456775\$R5498E5\' is not a clustered resource.To continue, add the resource to the cluster, or remove the mount point to cluster the shared disk."

To fix this I followed the below steps:

  • Remove the disks from the resource group
  • Remove the disks from the cluster
  • Bring the disks online in computer management
  • Format the Base disk that the mount points attach to
  • Recreate the mount points inside the Base disk
  • Re-add the disks to the cluster
  • Delete the Role and re-create it
  • Re-add the disks to the resource group
  • Re-create the dependencies from the mount point disks to the Base disk
  • Start SQL installation

Unable to bring the MSDTC resource online in a windows failover cluster - 0x3eb cluster resource

This morning, I had created my new Windows 2016 failover cluster and when I was trying tp create my MSDTC resource or for that matter any resource, I was unable to bring it online and it was failing at the network name bit. The disks were alright and were shared between the hosts but the resource just wouldn't come online!

After digging around, I figured out that my CNO (Cluster network object) did not have the "Create computer objects" permission, on the OU it was trying to create my MSDTC object. So all I had to do was go to the properties of my OU, which the objects was trying to be created and right click --> properties

1.JPG

On the next dialog box, go to the security tab and click the Advance button

2.JPG

Then click Add

3.JPG

Then click the "Select a principal" option

4.JPG

Here put the CNO name of your windows failover cluster, mine was ALSTAR$ and hit OK

5.JPG

In the permissions windows, make sure the "Create Computer Objects" permission is granted to the CNO and click OK.

6.JPG
7.JPG

Once this is done, try and bring your MSDTC resource online and hopefully it should come online without any issues!

-Alstar