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

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

If you are still running SQL Server 2005, 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

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

Cause
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
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.
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Properties

Article ID: 2003580 - Last Review: 10/09/2009 16:30:00 - Revision: 2.0

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

  • KB2003580
Feedback