none
Windows Server 2012 R2 Cluster Mount Points and Cluster Shared Volumes SQL Server 2016 Error

    Question

  • We have an environment as follows:

    2 node SQL Server Cluster running SQL Server 2016 instances.  The failover cluster is running on Windows Server 2012 R2.  All storage resides in a Compellant SAN.  We have just about run out of drive letters for new instances and want to move to mount points but I have run into an issue when trying to change the mount point volumes to Cluster Shared Volumes. 

    I used Microsoft Knowledgebase document 280297 and 819546 as reference to setup my Mount Points. 

    On each node of the cluster, I set up a mount point Root Disk and assigned it the same drive letter.  Created the mount point volumes and mapped them to the Root Disk.  Added the disks as disk resources for the cluster. However, I believe, I need to change the disks as a Cluster Shared Volume resource so each node in the cluster can have access to it during a failover.  

    In FC Manager, I changed the mount point from Available Storage to Cluster Shared Volume.  When I click on the Mount Point in Windows Explorer I get a "Location is not available" error.  I then looked at the disk in Data Management and the "Mount in the following empty NTFS folder" to the Root Disk is gone. 

    I attempted adding the disks as CSV's in two ways, first was adding both the root disk and the mount point disk/volume as CSV's.  Then I removed them both as CSV's and added only the mount point disk/volume.  Either way, I get the same error.

    This is my first time setting up mount points in a cluster, I have looked at so many websites and have't found any resolution.  Any advice will help.

    Tuesday, April 16, 2019 5:51 PM

All replies

  • Hi mr_congeniality,

    Please correct me if I misunderstood.

    Do you mean the mount points disappeared after you added these disks in Available Storage to CSV? Could you check if these disks are exposed to each cluster node as numbered volumes (mount points) under the %SystemDisk%ClusterStorage folder? Please refer to Use Cluster Shared Volumes in a failover cluster.

    Based on my test, I can see the mount point in the root disk.

    After adding the disk to CSV, I can see there are two volumns in the CSVFS file system. And the mount point is also not available. But Volume2 (the mount point) is available for all the nodes.



    Best Regards,
    Puzzle
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com



    Wednesday, April 17, 2019 9:13 AM
  • Hi Puzzle,

    I cannot post images to prove that I am seeing the same behavior in my environment because my account has not been verified yet.  However, I am experiencing the same results.  The root disk and mount point disk are both functional/accessible when they are set as Available Storage in FC Manager.  As soon as I change them to CSV's in FC Manager and try to access the mount point through Windows Explorer, I get the "Location is not available" error.  

    The Volumes are available through C:\ClusterStorage.  The icon for the root disk and mount point Volumes is different from the rest of the CSV Volumes, it is a folder icon.

    Thank you

    Wednesday, April 17, 2019 6:21 PM
  • Hi mr_congeniality,

    >>The Volumes are available through C:\ClusterStorage.  The icon for the root disk and mount point Volumes is different from the rest of the CSV Volumes, it is a folder icon.

    To the physical host system, the CSVs are seen as mount points in the standard file system. When we create a new CSV, Windows Failover Clustering creates CSV mount points for these volumes in that folder. I'm not sure if this is the excepted behavior since I'm not a Windows Server experts. You should check it out with experts in the Windows Server forum.

    Best Regards,
    Puzzle
    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Thursday, April 18, 2019 1:52 AM
  • Hi Puzzle, 

    >>The Volumes are available through C:\ClusterStorage.  The icon for the root disk and mount point Volumes is different from the rest of the CSV Volumes, it is a folder icon.

    This was more of an observation than anything.   I originally created a post in the Windows Server High Availability forum and was asked to post this question here.

    So, after your testing, do you see this "Location is not available" error as expected behavior in my scenario?  Or is should I be able to set up mount points as CSV's for use in the SQL Cluster?

    Thank you


    Monday, April 22, 2019 4:23 PM