You are currently offline, waiting for your internet to reconnect

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

Extended support for SQL Server 2005 ends on April 12, 2016

If you are still running SQL Server 2005 after April 12, 2016, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

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: 09/11/2010 10:06:00 - Revision: 1.3

Microsoft SQL Server 2005 Standard Edition, Microsoft SQL Server 2005 Workgroup Edition, Microsoft SQL Server 2005 Developer Edition, Microsoft SQL Server 2005 Enterprise Edition

  • kbclustering kbsql2005sp2fix kbsql2005clr kbsql2005setup kbexpertiseadvanced kbtshoot kbprb KB932897
Feedback
osoft.com/c.gif?DI=4050&did=1&t=">