Knowledge Base

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 "Longhorn"

Article ID: 932897

Article Last Modified on 3/26/2007

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

SYMPTOMS

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

CAUSE

In the new Windows Server "Longhorn" 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.

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.

Open Failover Cluster Manager.
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.
Rename the "New Service or application" group.
Click Add storage to add disk resources to the target location for the SQL Server 2005 installation.
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.

Start the cluster command-line tool.
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.
Run the following command to move the resources into the new SQL Server resource group:
```
cluster res "<ResourceName>" /move "<NewGroupName>"
```
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.

Keywords: kbsql2005sp2fix kbsql2005clr kbsql2005setup kbexpertiseadvanced kbtshoot kbprb KB932897

Microsoft KB Archive/932897

Contents