Error message Scenarios Troubleshooting tips The volume containing SQL Server INSTALLFAILOVERCLUSTER Applies to the /INSTALLSQLDATADIR and data directory %1 does not belong COMPLETEFAILOVERCLUSTER related data directory settings to the cluster Make sure that the path specified is on one of the disks selected for the cluster group (SLP setting /FAILOVERCLUSTERDISKS) Missing domain group. To continue, PREPAREFAILOVERCLUSTER Applies to provide a valid domain group for the the/SQLDOMAINGROUP Database Engine service. INSTALLFAILOVERCLUSTER setting Required only on Windows UPGRADE Server 2003 for PREPAREFAILOVERCLUSTER REPAIR and INSTALLFAILOVERCLUSTER, and UPGRADE from SQL Server 2000. May be required for REPAIR if the domain cannot be found. Invalid domain group. To continue, PREPAREFAILOVERCLUSTER Applies to the provide a valid domain group for the /SQLDOMAINGROUP setting INSTALLFAILOVERCLUSTER Database Engine service. Verify that the group account exists and is in the same UPGRADE domain forest as the domain to which the cluster node is REPAIR joined For Windows 2000 Server mixed-mode domains, this cannot be a domain local group. However, this situation is not diagnosed by Setup. It will show up at service startup with access-denied errors on the SQL Server error log. The service account is not valid. To PREPAREFAILOVERCLUSTER Applies to the continue, provide a domain account /SQLSVCACCOUNT setting for Database Engine service. INSTALLFAILOVERCLUSTER Verify that the service account specified exists and is in the REPAIR same domain forest as the domain to which the cluster node is joined The service account is not in the PREPAREFAILOVERCLUSTER Applies to the domain group. Ensure the service /SQLSVCACCOUNT setting account is a member of the domain INSTALLFAILOVERCLUSTER Verify that the service account group for the Database Engine. is in the domain group REPAIR specified by the /SQLDOMAINGROUP setting
Error message Scenarios Troubleshooting tips The volume containing SQL Server data directory %1 does not belong to the cluster INSTALLFAILOVERCLUSTER COMPLETEFAILOVERCLUSTER Applies to the /INSTALLSQLDATADIR and related data directory settings Make sure that the path specified is on one of the disks selected for the cluster group (SLP setting /FAILOVERCLUSTERDISKS) Missing domain group. To continue, provide a valid domain group for the Database Engine service. PREPAREFAILOVERCLUSTER INSTALLFAILOVERCLUSTER UPGRADE REPAIR Applies to the/SQLDOMAINGROUP setting Required only on Windows Server 2003 for PREPAREFAILOVERCLUSTER and INSTALLFAILOVERCLUSTER, and UPGRADE from SQL Server 2000. May be required for REPAIR if the domain cannot be found. Invalid domain group. To continue, provide a valid domain group for the Database Engine service. PREPAREFAILOVERCLUSTER INSTALLFAILOVERCLUSTER UPGRADE REPAIR Applies to the /SQLDOMAINGROUP setting Verify that the group account exists and is in the same domain forest as the domain to which the cluster node is joined For Windows 2000 Server mixed-mode domains, this cannot be a domain local group. However, this situation is not diagnosed by Setup. It will show up at service startup with access-denied errors on the SQL Server error log. The service account is not valid. To continue, provide a domain account for Database Engine service. PREPAREFAILOVERCLUSTER INSTALLFAILOVERCLUSTER REPAIR Applies to the /SQLSVCACCOUNT setting Verify that the service account specified exists and is in the same domain forest as the domain to which the cluster node is joined The service account is not in the domain group. Ensure the service account is a member of the domain group for the Database Engine. PREPAREFAILOVERCLUSTER INSTALLFAILOVERCLUSTER REPAIR Applies to the /SQLSVCACCOUNT setting Verify that the service account is in the domain group specified by the /SQLDOMAINGROUP setting
SQLServer2008FailoverCluster.docx