Article ID: 971818 - Last Review: May 27, 2009 - Revision: 1.3

Error message when you apply a software update or a security patch to a SQL server 2005 instance: "Error:29565. SQL Server Setup cannot upgrade the specified instance because the previous upgrade did not complete"

View products that this article applies to.
System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
Expand all | Collapse all

SYMPTOMS

When you try to install a Microsoft SQL Server 2005 service pack or a SQL Server 2005 hotfix, the installation may fail with the following error message in the Summary log file for the hotfix:

Product: Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 29565
Error Description : MSP Error: 29565 SQL Server Setup cannot upgrade the specified instance because the previous upgrade did not complete. Start the Remote Registry service and go to Add/Remove Programs, select the Change button for Microsoft SQL Server 2005, and then select SQL instance MSSQLSERVER and complete the setup.

Note When you apply a SQL Server update through Microsoft Update, the same error number is reported as 737D (The hexadecimal value for 29565).

Additionally, the msp.log file for the software update will have the following information:

MSI (s) (40!E0) [21:44:55:632]: Product: Microsoft SQL Server 2005 -- Error 29565.

Note The summary log file and msp.log file for the software update is located in the %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix folder.
Back to the top

CAUSE

The SQL Server Setup Program cannot upgrade the specified instance because the previous upgrade did not complete. The issue occurs when the following conditions are true:
  • An attempt was made to upgrade the SQL instance.
  • The update process failed after reaching a point of no return.
In this scenario, SQL Server is left in a state that cannot be updated.
Back to the top

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Back to the top

RESOLUTION

To resolve this problem, repair the SQL Server 2005 instance by using Add or Remove Programs in Control Panel. To do this, follow these steps:
  1. In Control Panel, open Add or Remove Programs.
  2. In the Currently installed programs list, click the instance of Microsoft SQL Server 2005 to repair and then click Change.
  3. In the Component Selection page, select Database Engine and then click Next.
  4. In the Feature Maintenance page, select Database Engine and  then click Next. The SQL server installation wizard starts.
  5. To continue, click Next on the SQL server 2005 setup page.
  6. Click Next on the System Configuration Check page.
  7. In Change or Remove Instance page, select Complete the suspended installation.
  8. Click Next on the Error and Usage Report Settings page. Optional, you can select one or both the boxes on this screen.
  9. Click Install on the Ready to Update page.
  10. Click Next on the Setup Progress page.
  11. Click Finish on the Completing Microsoft SQL Server 2005 Setup page.
Back to the top
APPLIES TO
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Workgroup Edition
Back to the top
Keywords: 
kbnomt kbrapidpub KB971818
Back to the top