Cluster shared disk available check failed error when installing Microsoft SQL Server 2008 to an MSCS cluster configured with Storage Foundation for Windows

Problem

Cluster shared disk available check failed error when installing Microsoft SQL Server 2008 to an MSCS cluster configured with Storage Foundation for Windows

Solution

SQL Server 2008 installation executes Setup Support Rules in order to verify system configuration. The checking rule for cluster shared disks may fail if the Distributed Transaction Coordinator service (MSDTC) resource has been configured to use the same storage used for SQL Server as shown in Fig 1.

 
Fig 1. SQL installer shared disk check failing

When clustering SQL Server 2008 with Storage Foundation for Windows in a Microsoft (MSCS) cluster, an MSDTC resource and a SQL Service Group must be configured before installing SQL. If the MSDTC resource is included in the SQL Service group, the shared storage does not appear to be detected correctly.

Cause:
This issue can occur where the MSDTC resource is included in the SQL Service group, or the Volume Manager Disk Group (VMDg) resource has dependencies set.

Solution:
A recommended configuration is to add the MSDTC resource to the Cluster Service Group, or create a dedicated Service Group for MSDTC with IP, Network Name and VMDg resources. In this configuration, the SQL Server Service Group contains unique IP, Network Name and VMDg resources in the cluster.

In addition, verify that the VMDg resource in the SQL Server Service Group does not depend on any other resources. Check that the dependencies tab on the properties of the VMDg resource is empty.

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)