none
Install new sqlserver 2008 R2 named instance cause error Rule "Cluster shared disk available check" failed

    Question

  • Hi,

    All the VDisks which are presented on both nodes of the SQL server 2008 R2 cluster are online and showing within the Failover cluster manager.

     

    And we would like to use and select 2 dedicated VDisks from the list for the new Named SQL Instance ( 1 for the Data and  1 for the Logs ) as  ( Cluster Disk 3 & Cluster Disk 8 ).

     

    Note : those selected disks are newly prepared and not being used yet in any other instances since we have only 1 instance now created which is the default one and it uses other different Vdisks ( Cluster Disk 1 & Cluster Disk 6 ).

     

    We are still facing the same issue whenever we try to run the SQL 2008 R2 named instance setup, “Disk available check” rule fails

      

    msdtc  is configured as separate resource group.

    quorum disk is also configured

     

    Please help me to solve the issue

     

    Thanks

    SVA_IN,

     

     

    Tuesday, March 29, 2011 4:31 AM

Answers

All replies

  • Have you created an empty service and applications and is installing SQL in that ? If yes make sure that you move the disks to the service(group) that you created for sql server and then try the installation.

    Try to follow Method 2 in the article http://support.microsoft.com/kb/932897 and see whether it helps.

     

     


    Regards, Ashwin Menon My Blog -> sqllearnings.wordpress.com
    Tuesday, March 29, 2011 5:20 AM
  • http://msdn.microsoft.com/en-us/library/ms179410.aspx 

    A failover cluster instance can run on one or more computers that are participating nodes of a failover cluster. A failover cluster instance contains:

    • A combination of one or more disks in a Microsoft Cluster Service (MSCS) cluster group, also known as a resource group. Each resource group can contain at most one instance of SQL Server.


    Regards, Ashwin Menon My Blog -> sqllearnings.wordpress.com
    Tuesday, March 29, 2011 7:35 AM
  • Can you check this KB article.

    http://support.microsoft.com/kb/955780

    Can you make sure that the disk is not dependent on any other resource, or any other resource is dependent on this disk


    Regards, Ashwin Menon My Blog -> sqllearnings.wordpress.com
    Tuesday, March 29, 2011 10:23 AM