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

Article translations Article translations
Article ID: 932897 - View products that this article applies to.
Expand all | Collapse all

On This Page

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.

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.

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.

STATUS

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

Properties

Article ID: 932897 - Last Review: September 11, 2010 - Revision: 1.3
APPLIES TO
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
Keywords: 
kbclustering kbsql2005sp2fix kbsql2005clr kbsql2005setup kbexpertiseadvanced kbtshoot kbprb KB932897

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com