Windows XP Pro
SQL Server 2005 Express
SQL Server 2005 Standard
I installed the service pack for SQL Server Express first.
Then I tried to install the service pack for SQL Server. I got the error message, "A recently applied update, KB913090, failed to install.", while it was upgrading the Setup Support Files.
Jonathan Allen
Log follows...
04/22/2006 10:52:34.781 ================================================================================
04/22/2006 10:52:34.875 Hotfix package launched
04/22/2006 10:53:47.546 Attempting to install instance: SQL Server Native Client
04/22/2006 10:53:47.578 Attempting to install target: RADICALJAY
04/22/2006 10:53:47.593 Attempting to install file: sqlncli.msi
04/22/2006 10:53:47.687 Attempting to install file: \\RADICALJAY\c$\b1f5502657526de4ed0c\HotFixSqlncli\Files\sqlncli.msi
04/22/2006 10:53:47.687 Creating MSI install log file at: C:\WINDOWS\Hotfix\Redist9\Logs\Redist9_Hotfix_KB913090_sqlncli.msi.log
04/22/2006 10:53:47.703 Successfully opened registry key: Software\Policies\Microsoft\Windows\Installer
04/22/2006 10:53:47.718 Failed to read registry key: Debug
04/22/2006 10:53:49.578 MSP returned 0: The action completed successfully.
04/22/2006 10:53:49.765 Successfully opened registry key: Software\Policies\Microsoft\Windows\Installer
04/22/2006 10:53:49.781 Failed to read registry key: Debug
04/22/2006 10:53:49.781 Successfully installed file: \\RADICALJAY\c$\b1f5502657526de4ed0c\HotFixSqlncli\Files\sqlncli.msi
04/22/2006 10:53:49.796 Successfully installed target: RADICALJAY
04/22/2006 10:53:49.812 Successfully installed instance: SQL Server Native Client
04/22/2006 10:53:49.828
04/22/2006 10:53:49.828 Product Status Summary:
04/22/2006 10:53:49.843 Product: SQL Server Native Client
04/22/2006 10:53:49.859 SQL Server Native Client (RTM ) - Success
04/22/2006 10:53:49.859
04/22/2006 10:53:49.875 Product: Setup Support Files
04/22/2006 10:53:49.890 Setup Support Files (RTM ) - Not Applied
04/22/2006 10:53:49.890
04/22/2006 10:53:49.906 Product: Database Services
04/22/2006 10:53:49.921 Database Services (RTM 1399 ENU) - Not Applied
04/22/2006 10:53:49.937 Analysis Services (RTM 1399 ENU) - Not Applied
04/22/2006 10:53:49.937 Reporting Services (RTM 1399 ENU) - Not Applied
04/22/2006 10:53:49.953
04/22/2006 10:53:49.968 Product: Database Services
04/22/2006 10:53:49.968 Database Services (SP1 2047 ENU) - NA
04/22/2006 10:53:49.984 Details: Instances of SQL Server Express cannot be updated by using this Service Pack installer. To update instances of SQL Server Express, use the SQL Server Express Service Pack installer.
04/22/2006 10:53:50.000
04/22/2006 10:53:50.015 Product: Notification Services
04/22/2006 10:53:50.015 Notification Services (RTM 1399 ENU) - Not Applied
04/22/2006 10:53:50.031
04/22/2006 10:53:50.046 Product: Integration Services
04/22/2006 10:53:50.046 Integration Services (RTM 1399 ENU) - Not Applied
04/22/2006 10:53:50.062
04/22/2006 10:53:50.078 Product: Client Components
04/22/2006 10:53:50.093 Client Components (RTM 1399 ENU) - Not Applied
04/22/2006 10:53:50.093
04/22/2006 10:53:50.109 Product: MSXML 6.0 Parser
04/22/2006 10:53:50.125 MSXML 6.0 Parser (RTM ) - Not Applied
04/22/2006 10:53:50.125
04/22/2006 10:53:50.140 Product: SQLXML4
04/22/2006 10:53:50.156 SQLXML4 (RTM ) - Not Applied
04/22/2006 10:53:50.171
04/22/2006 10:53:50.171 Product: Backward Compatibility
04/22/2006 10:53:50.187 Backward Compatibility (RTM ) - Not Applied
04/22/2006 10:53:50.203
04/22/2006 10:53:50.203 Product: Microsoft SQL Server VSS Writer
04/22/2006 10:53:50.218 Microsoft SQL Server VSS Writer (RTM ) - Not Applied
04/22/2006 10:53:50.234
This appears to be the log from trying to apply SP1 to your Express instance.
04/22/2006 10:53:49.968 Database Services (SP1 2047 ENU) - NA
04/22/2006 10:53:49.984 Details: Instances of SQL Server Express cannot be updated by using this Service Pack installer. To update instances of SQL Server Express, use the SQL Server Express Service Pack installer.
Can you share out the msp log from the second attempt? The logs are in the %windir%\hotfix folder. If you do a search for "return value 3", that may lead you to the failed component log.
Thanks,
Samuel Lester (MSFT)
This is the new log file from the Service Pack GUI...
04/23/2006 23:12:21.656 ================================================================================
04/23/2006 23:12:21.671 Hotfix package launched
04/23/2006 23:13:02.750 Attempting to install instance: SQL Server Native Client
04/23/2006 23:13:02.796 Attempting to install target: RADICALJAY
04/23/2006 23:13:02.812 Attempting to install file: sqlncli.msi
04/23/2006 23:13:03.031 Attempting to install file: \\RADICALJAY\c$\124b99e6f03eb11ec06df9\HotFixSqlncli\Files\sqlncli.msi
04/23/2006 23:13:03.031 Creating MSI install log file at: C:\WINDOWS\Hotfix\Redist9\Logs\Redist9_Hotfix_KB913090_sqlncli.msi.log
04/23/2006 23:13:03.046 Successfully opened registry key: Software\Policies\Microsoft\Windows\Installer
04/23/2006 23:13:03.062 Failed to read registry key: Debug
04/23/2006 23:13:05.468 MSP returned 0: The action completed successfully.
04/23/2006 23:13:05.656 Successfully opened registry key: Software\Policies\Microsoft\Windows\Installer
04/23/2006 23:13:05.687 Failed to read registry key: Debug
04/23/2006 23:13:05.703 Successfully installed file: \\RADICALJAY\c$\124b99e6f03eb11ec06df9\HotFixSqlncli\Files\sqlncli.msi
04/23/2006 23:13:05.718 Successfully installed target: RADICALJAY
04/23/2006 23:13:05.718 Successfully installed instance: SQL Server Native Client
04/23/2006 23:13:05.734
04/23/2006 23:13:05.750 Product Status Summary:
04/23/2006 23:13:05.750 Product: SQL Server Native Client
04/23/2006 23:13:05.765 SQL Server Native Client (RTM ) - Success
04/23/2006 23:13:05.781
04/23/2006 23:13:05.796 Product: Setup Support Files
04/23/2006 23:13:05.796 Setup Support Files (RTM ) - Not Applied
04/23/2006 23:13:05.812
04/23/2006 23:13:05.828 Product: Database Services
04/23/2006 23:13:05.828 Database Services (RTM 1399 ENU) - Not Applied
04/23/2006 23:13:05.843 Analysis Services (RTM 1399 ENU) - Not Applied
04/23/2006 23:13:05.859 Reporting Services (RTM 1399 ENU) - Not Applied
04/23/2006 23:13:05.875
04/23/2006 23:13:05.875 Product: Database Services
04/23/2006 23:13:05.890 Database Services (SP1 2047 ENU) - NA
04/23/2006 23:13:05.906 Details: Instances of SQL Server Express cannot be updated by using this Service Pack installer. To update instances of SQL Server Express, use the SQL Server Express Service Pack installer.
04/23/2006 23:13:05.906
04/23/2006 23:13:05.921 Product: Notification Services
04/23/2006 23:13:05.937 Notification Services (RTM 1399 ENU) - Not Applied
04/23/2006 23:13:05.953
04/23/2006 23:13:05.953 Product: Integration Services
04/23/2006 23:13:05.968 Integration Services (RTM 1399 ENU) - Not Applied
04/23/2006 23:13:05.984
04/23/2006 23:13:05.984 Product: Client Components
04/23/2006 23:13:06.000 Client Components (RTM 1399 ENU) - Not Applied
04/23/2006 23:13:06.031
04/23/2006 23:13:06.046 Product: MSXML 6.0 Parser
04/23/2006 23:13:06.046 MSXML 6.0 Parser (RTM ) - Not Applied
04/23/2006 23:13:06.062
04/23/2006 23:13:06.078 Product: SQLXML4
04/23/2006 23:13:06.078 SQLXML4 (RTM ) - Not Applied
04/23/2006 23:13:06.093
04/23/2006 23:13:06.109 Product: Backward Compatibility
04/23/2006 23:13:06.109 Backward Compatibility (RTM ) - Not Applied
04/23/2006 23:13:06.125
04/23/2006 23:13:06.140 Product: Microsoft SQL Server VSS Writer
04/23/2006 23:13:06.156 Microsoft SQL Server VSS Writer (RTM ) - Not Applied
04/23/2006 23:13:06.156
I didn't find "return value 3", but this was interesting...
"C:\WINDOWS\Hotfix\Redist9\Logs\Redist9_Hotfix_KB913090_SqlSupport.msp.log"
=== Verbose logging started: 4/23/2006 23:13:06 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: C:\WINDOWS\system32\msiexec.exe ===
MSI (c) (30:E8) [23:13:06:375]: Resetting cached policy values
MSI (c) (30:E8) [23:13:06:375]: Machine policy value 'Debug' is 0
MSI (c) (30:E8) [23:13:06:375]: ******* RunEngine:
******* Product: {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}
******* Action:
******* CommandLine: **********
MSI (c) (30:E8) [23:13:06:375]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (30:E8) [23:13:06:375]: Grabbed execution mutex.
MSI (c) (30:E8) [23:13:06:375]: Cloaking enabled.
MSI (c) (30:E8) [23:13:06:375]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (30:E8) [23:13:06:390]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (18:88) [23:13:06:390]: Grabbed execution mutex.
MSI (s) (18:9C) [23:13:06:390]: Resetting cached policy values
MSI (s) (18:9C) [23:13:06:390]: Machine policy value 'Debug' is 0
MSI (s) (18:9C) [23:13:06:390]: ******* RunEngine:
******* Product: {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}
******* Action:
******* CommandLine: **********
MSI (s) (18:9C) [23:13:06:390]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (18:9C) [23:13:06:390]: End dialog not enabled
MSI (s) (18:9C) [23:13:06:390]: Original package ==> c:\WINDOWS\Installer\2b422ff9.msi
MSI (s) (18:9C) [23:13:06:390]: Package we're running from ==> c:\WINDOWS\Installer\2b422ff9.msi
MSI (s) (18:9C) [23:13:06:390]: APPCOMPAT: looking for appcompat database entry with ProductCode '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}'.
MSI (s) (18:9C) [23:13:06:390]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (18:9C) [23:13:06:390]: MSCOREE not loaded loading copy from system32
MSI (s) (18:9C) [23:13:06:500]: File will have security applied from OpCode.
MSI (s) (18:9C) [23:13:06:593]: Original patch ==> \\RADICALJAY\c$\124b99e6f03eb11ec06df9\HotFixSqlSupport\Files\SqlSupport.msp
MSI (s) (18:9C) [23:13:06:593]: Patch we're running from ==> C:\WINDOWS\Installer\7d5500e.msp
MSI (s) (18:9C) [23:13:06:593]: SOFTWARE RESTRICTION POLICY: Verifying patch --> '\\RADICALJAY\c$\124b99e6f03eb11ec06df9\HotFixSqlSupport\Files\SqlSupport.msp' against software restriction policy
MSI (s) (18:9C) [23:13:06:593]: Note: 1: 2262 2: DigitalSignature 3: -2147287038
MSI (s) (18:9C) [23:13:06:593]: SOFTWARE RESTRICTION POLICY: \\RADICALJAY\c$\124b99e6f03eb11ec06df9\HotFixSqlSupport\Files\SqlSupport.msp is not digitally signed
MSI (s) (18:9C) [23:13:06:609]: SOFTWARE RESTRICTION POLICY: \\RADICALJAY\c$\124b99e6f03eb11ec06df9\HotFixSqlSupport\Files\SqlSupport.msp is permitted to run at the 'unrestricted' authorization level.
MSI (s) (18:9C) [23:13:06:625]: SequencePatches starts. Product code: {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}, Product version: 9.00.2047.00, Upgrade code: {3A91FA19-A197-467C-850F-0AFE90899371}, Product language 1033
MSI (s) (18:9C) [23:13:06:625]: PATCH SEQUENCER WARNING: \\RADICALJAY\c$\124b99e6f03eb11ec06df9\HotFixSqlSupport\Files\SqlSupport.msp patch will not be sequenced because it does not contain any transform that may apply to product!
MSI (s) (18:9C) [23:13:06:625]: SequencePatches returns success.
MSI (s) (18:9C) [23:13:06:625]: Final Patch Application Order:
MSI (s) (18:9C) [23:13:06:625]: Other Patches:
MSI (s) (18:9C) [23:13:06:625]: Unknown\Absent: {EE92F683-5F5C-4970-BB0B-9AC591B60268} - \\RADICALJAY\c$\124b99e6f03eb11ec06df9\HotFixSqlSupport\Files\SqlSupport.msp
MSI (s) (18:9C) [23:13:06:625]: Product: Microsoft SQL Server Setup Support Files (English) - Update '{EE92F683-5F5C-4970-BB0B-9AC591B60268}' could not be installed. Error code 1642. Additional information is available in the log file C:\WINDOWS\Hotfix\Redist9\Logs\Redist9_Hotfix_KB913090_SqlSupport.msp.log.
MSI (s) (18:9C) [23:13:06:625]: Note: 1: 1708
MSI (s) (18:9C) [23:13:06:625]: Note: 1: 2729
MSI (s) (18:9C) [23:13:06:671]: Note: 1: 2729
MSI (s) (18:9C) [23:13:06:671]: Product: Microsoft SQL Server Setup Support Files (English) -- Installation failed.
MSI (s) (18:9C) [23:13:06:671]: Attempting to delete file C:\WINDOWS\Installer\7d5500e.msp
MSI (s) (18:9C) [23:13:06:671]: MainEngineThread is returning 1642
The upgrade patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program. Verify that the program to be upgraded exists on your computer an
d that you have the correct upgrade patch.
c:\WINDOWS\Installer\2b422ff9.msi
MSI (c) (30:E8) [23:13:06:671]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (30:E8) [23:13:06:671]: MainEngineThread is returning 1642
=== Verbose logging stopped: 4/23/2006 23:13:06 ===
We're getting a KB article ready for this.
SP1 fails with "Unable to install Windows Installer MSP file" for "Setup Support Files"
Workaround:
1/ Save the registry contents of:
KeyName: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Bootstrap\MSIRefCount
Value: Uninstall
2/ Uninstall SqlSupport.msi from Add/Remove control panel
3/ Install SqlSupport.msi version 1399 from the RTM media.
4/ Restore the registry contents that were saved in step 1.
Thanks Jeffrey!
This worked for me as well. I posted visual instructions on my blog at VSTeamSystemCentral.com.
:{> Andy
|||Worked for me too. Thanks,
Jonathan
|||Works for me, too!
THANK YOU!
Robert.
|||I downloaded SP2 this week and I'm getting what appears to be the same error...was this not resolved as part of the SP2 release? Do the same steps above apply for SP2?
Thanks
No comments:
Post a Comment