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.
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.
To work around this problem, use one of the following methods.
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
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.
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:
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.
cluster group "<NewGroupName>" /create
- 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.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Article ID: 932897 - Last Review: September 11, 2010 - 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|