Microsoft Security Update (KB954606) for SQL server 2005 Service Pack 2, (KB970892) Service Pack 3 and (KB2463332) Service Pack 4 fails to patch the named Backup Exec (BKUPEXEC) SQL instance.

Article:TECH66134  |  Created: 2008-01-17  |  Updated: 2014-07-07  |  Article URL http://www.symantec.com/docs/TECH66134
Article Type
Technical Solution

Product(s)

Issue



Microsoft Security Update (KB954606) for SQL server 2005 Service Pack 2, (KB970892) Service Pack 3 and (KB2463332) Service Pack 4 fails to patch the named Backup Exec (BKUPEXEC) SQL instance.


Error



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 BKUPEXEC.


Solution



Microsoft SQL 2005 patch (KB 954606) Service Pack 2, (KB970892) Service Pack 3 and (KB2463332) Service Pack 4 fails to install when attempting to patch the named Backup Exec SQL instance (BKUPEXEC) manually or thru Windows Update.
 

 
Reviewing the SQL installation logs (C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\summary.txt and C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB954606_sqlrun_sql.msp.log) the following error is reported:
 

 
----------------------------------------------------------------------------------
 
Product Installation Status
 
Product: SQL Server Database Services 2005 (BKUPEXEC)
 
Product Version (Previous): 3042
 
Product Version (Final)   :
 
Status: Failure
 
Log File C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB954606_sqlrun_sql.msp.log
 
SQL Express Features      :
 
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 BKUPEXEC and complete the setup.
 
----------------------------------------------------------------------------------
 

 
Errors reported in the Application Log:
 

 
----------------------------------------------------------------------------------
 
Event Type: Error
 
Event Source: MsiInstaller
 
Event Category: None
 
Event ID: 10005
 
Date: 12/18/2008
 
Time: 8:04:59 AM
 
User: Administrator
 
Computer: SERVER01
 
Description:
 
Product: Microsoft SQL Server 2005 Express Edition -- 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 BKUPEXEC and complete the setup.
 

 

 
Event Type: Error
 
Event Source: MsiInstaller
 
Event Category: None
 
Event ID: 1023
 
Date: 12/18/2008
 
Time: 8:04:59 AM
 
User: Administrator
 
Computer: SERVER01
 
Description:
 
Product: Microsoft SQL Server 2005 Express Edition - Update 'GDR 3068 for SQL Server Database Services 2005 ENU (KB954606)' could not be installed. Error code 1603. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB954606_sqlrun_sql.msp.log.
 
----------------------------------------------------------------------------------
 

 
Errors reported in the System Log:
 
----------------------------------------------------------------------------------
 
Event Type: Error
 
Event Source: Windows Update Agent
 
Event Category: Installation
 
Event ID: 20
 
Date: 12/17/2008
 
Time: 7:55:35 AM
 
User: N/A
 
Computer: SERVER01
 
Description:
 
Installation Failure: Windows failed to install the following update with error 0x80070643: Security Update for SQL Server 2005 Service Pack 2 (KB954606).
 
----------------------------------------------------------------------------------
 

 
RESOLUTION:
 

 
On the Backup Exec Media Server change the following registry value from 1 to 0 and install the Microsoft SQL patch:
 

 
WARNING: Incorrect use of the Windows registry editor may prevent the operating system from functioning properly. Great care should be taken when making changes to a Windows registry. Registry modifications should only be carried-out by persons experienced in the use of the registry editor application. It is recommended that a complete backup of the registry and workstation be made prior to making any registry changes.
 

 
Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQLServer\MSSQL.1\Setup\Resume
 
Change the value data from 1 to 0 (Figure 1)
 

 
Note: If multiple SQL instances are present on the Backup Exec Media server the registry key could be (MSSQL, MSSQL.2, etc)
 

 
(FIGURE 1)
 
 
 

 
If the media server is a 64bit machine, edit the  below registry key from 1 to 0 (Figure 2), and rerun the patch installation.
 

 
HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\Microsoft Sql Server\MSSQL.1\Setup\Resume
 

 
 
 

 
For information about downloading and installing the Security Update for SQL Server 2005 Service Pack 2, please see the following Microsoft KB articles:
 

 
MS08-052: Description of the security update for GDI+ for SQL Server 2005 Service Pack 2 GDR: September 9, 2008
 

 
Security Update for SQL Server 2005 Service Pack 2 (KB954606)
 

 

 
For information about downloading and installing the Security Update for SQL Server 2005 Service Pack 3, please see the following Microsoft KB articles:
 

 
MS09-062: Description of the security update for SQL Server 2005 Service Pack 3 GDR: October 13, 2009
 

 
Microsoft Security Bulletin MS09-062 - Critical
 
 
 
For information about downloading and installing the Security Update for SQL Server 2005 Service Pack 4, please see the following Microsoft KB articles:
 

 

List of the issues that are fixed in SQL Server 2005 Service Pack 4

http://support.microsoft.com/kb/2463332


 
Microsoft SQL Server 2005 Express Edition Service Pack

http://www.microsoft.com/download/en/details.aspx?id=184



Legacy ID



316661


Article URL http://www.symantec.com/docs/TECH66134


Terms of use for this information are found in Legal Notices