Service pack ,Hotfix and CU installation for SQL Server 2005 might fail with “Unable to install Windows Installer MSI file“
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