Microsoft KB Archive Search

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.

  1. Home
  2. You may get "The group or resource is not in the correct state to perform the requested operation" when rebuilding system databases on a SQL Server 2005 virtual server

You may get "The group or resource is not in the correct state to perform the requested operation" when rebuilding system databases on a SQL Server 2005 virtual server

Symptoms

Consider the following scenario:

  • In a cluster environment you install either a default or named instance of SQL Server 2005.
  • You update this instance with either of the following for SQL Server 2005
    • Cumulative Package 13 (9.00.3325) or higher version for Service Pack 2
    • Service Pack 3 or any Cumulative Update package for Service Pack 3

In this scenario, if you rebuild system databases of the instance as per the instructions documented in Books Online, the setup process fails with the following message logged in Summary.txt file.

Error String    : The setup has encountered an error while Upgrading Components. The error: -2147019873
Error message: The group or resource is not in the correct state to perform the requested operation.
Error Number    : 29550

↑ Back to the top

Cause

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

↑ Back to the top

Resolution

You can use the following procedure to resolve the problem:

  1. On the cluster node where SQL Server is currently active, open Services applet and stop the SQL Server service for the instance  whose system databases are being rebuilt.
  2. In Cluster Administrator bring the SQL Server resource Online.

↑ Back to the top

Keywords: vkball, kb

↑ Back to the top

Article Info
Article ID : 2003580
Revision : 1
Created on : 1/8/2017
Published on : 10/9/2009
Exists online : False
Views : 261