Karthick PK 's Blog

Karthick PK's technical blog covering topics such as SQLServer troubleshooting, technologies and security.

Service pack ,Hotfix and CU installation for SQL Server 2005 might fail with “Unable to install Windows Installer MSI file“

Service pack ,Hotfix and CU installation for SQL Server 2005 might fail with “Unable to install Windows Installer MSI file“

Rate This
  • Comments 0

Installation of SQL Server 2005 Service pack ,Hotfix and CU  would fail fails with “Unable to install Windows Installer MSI file“ and message box “ A recently applied update failed to install”

You will find below errors in setup logs.

Summary.txt:
Product Installation Status
Product                   : Setup Support Files
Product Version (Previous):
Product Version (Final)   :
Status                    : Failure
Log File                  : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KBxxxx_SqlSupport.msi.log
Error Number              : 1635
Error Description         : Unable to install Windows Installer MSI file
----------------------------------------------------------------------------------

Hotfix.log:-

Copy Engine: Creating MSI install log file at: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KBXXXXX_SqlSupport.msi.log
Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
Registry: Cannot read registry key value "Debug", error 2
Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
Registry: Cannot read registry key value "Debug", error 0
Copy Engine: Error, unable to install MSI file: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Cache\SQLSupport\x64\1033\SqlSupport.msi
The following exception occurred: Unable to install Windows Installer MSI file  Date: 05/04/2010 13:31:36.698  File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\copyengine.cpp  Line: 1429
Watson: Param1 = Unknown

SQLSupport.msi.log

MSI (s) (24:78) [ ]: MainEngineThread is returning 1635

This patch package could not be opened.  Verify that the patch package exists and that you can access it, or contact the application vendor to verify that this is a valid Windows Installer patch package.

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi

MSI (c) (3C:14) [ ]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1

MSI (c) (3C:14) [ ]: MainEngineThread is returning 1635

 

 

Resolution:

1. Uninstall SQL Server setup support files from add or remove programs (You will get a warning:26002 The following products depend on Microsoft SQL Server 2005 …..) You can ignore the warning and continue to uninstall SQL Server setup support files.

2.  Unzip (or) Extract the installer (Service pack /Hotfix / CU) using /X parameter from command prompt (Example: d:>SQLServer2005SP3-KB955706-x86-ENU.exe /x).

3. Invoke the hotfix.exe and complete the upgrade.

 

Hope this helps.

Thank you,

Karthick P.K |Technical Lead | Microsoft SQL Server Support 

My Facebook Page |My Site| Blog space| Twitter

Comments
Leave a Comment
  • Please add 4 and 4 and type the answer here:
  • Post