Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

You cannot find SQL Server cluster resources in Failover Cluster Manager after you install a SQL Server 2005 failover cluster on a computer that is running Windows Server 2008


Symptoms

After you install a Microsoft SQL Server 2005 failover cluster on a computer that is running Windows Server 2008, you cannot find SQL Server cluster resources in Failover Cluster Manager.

↑ Back to the top


Cause

In the new Windows Server 2008 cluster, all physical disks that can be clustered are in the Available Storage group until they are used by an application. After you install a SQL Server 2005 failover cluster by using the default disk group, SQL Server cluster resources are located in the Available Storage group. However, the Available Storage group is not visible in Failover Cluster Manager.

↑ Back to the top


Workaround

To work around this problem, use one of the following methods.

Method 1

We recommend that you use this method if you have the original release version of SQL Server 2005 installed.
  1. Install SQL Server 2005 Service Pack 2 (SP2).

    Note SQL Server 2005 SP2 performs the following operations:
    • Creates a new group for the disk resource

      Note SQL Server 2005 SP2 bases the new group on the network name resource.
    • Moves the disk resource from the Available Storage group into the new group
    • Moves all SQL Server 2005 resources into the new group

Method 2

We recommend that you use this method before you install the original version of SQL Server 2005. If you have already installed SQL Server 2005, you must uninstall SQL Server 2005 before you use this method.
  1. Open Failover Cluster Manager.
  2. Right-click Services and Applications, point to More Actions, and then click Create Empty Service or Application. A group that is named "New Service or application" is created.
  3. Rename the "New Service or application" group.
  4. Click Add storage to add disk resources to the target location for the SQL Server 2005 installation.
  5. Install the original version of SQL Server 2005. During the installation, select the renamed group on the Cluster Group Selection page.

Method 3

We recommend that you use this method if you have already installed SQL Server 2005 or SQL Server 2005 Service Pack 1 (SP1) and do not want to uninstall SQL Server 2005.
  1. Start the cluster command-line tool.
  2. Run the following command to create a SQL Server resource group:
    cluster group "<NewGroupName>" /create
    Note In this step and in the following step, the placeholder <NewGroupName> represents the name of the SQL Server resource group that this command creates.
  3. Run the following command to move the resources into the new SQL Server resource group:
    cluster res "<ResourceName>" /move "<NewGroupName>"
  4. If you are prompted to move dependencies, click Yes.

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top


Keywords: kbclustering, kbsql2005sp2fix, kbsql2005clr, kbsql2005setup, kbexpertiseadvanced, kbtshoot, kbprb, kb

↑ Back to the top

Article Info
Article ID : 932897
Revision : 1
Created on : 1/7/2017
Published on : 9/11/2010
Exists online : False
Views : 402