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

Article:TECH128030  |  Created: 2010-01-26  |  Updated: 2010-01-29  |  Article URL http://www.symantec.com/docs/TECH128030
Article Type
Technical Solution


Environment

Issue



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.


Legacy ID



347979


Article URL http://www.symantec.com/docs/TECH128030


Terms of use for this information are found in Legal Notices