October 15, 2009 at 9:01 pm
Hi
I am trying to update SQL Server 2005 on our development server.
We are running SQL Server 2005 Development edition, which I am trying to update to SP3, so that we can test our applications before deploying on our production servers.
I was having problems with the rest of the install, due to files missing from the Windows installer cache, but I managed to restore these files from the original installation and patches, and the rest of the install is no working Ok.
Does anyone know how I can either re-install the client components, or resolve the issues with the service pack update?
The Client Components section is failing with the error below.
[font="Courier New"]
----------------------------------------------------------------------------------
Product : Client Components
Product Version (Previous): 3257
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB955706_sqlrun_tools.msp.log
Error Number : 1646
Error Description : Unable to install Windows Installer MSP file
----------------------------------------------------------------------------------
[/font]
The content of SQLTools9_Hotfix_KB955706_sqlrun_tools.msp.log is:
[font="Courier New"]
=== Verbose logging started: 16/10/2009 13:49:42 Build type: SHIP UNICODE 3.01.4000.4042 Calling process: d:\65d5346c9964167a51a661fd7445\hotfix.exe ===
MSI (c) (24:E0) [13:49:42:311]: Resetting cached policy values
MSI (c) (24:E0) [13:49:42:311]: Machine policy value 'Debug' is 0
MSI (c) (24:E0) [13:49:42:311]: ******* RunEngine:
******* Product: {90032DD0-ABEE-4424-AC1E-B076BDD4E350}
******* Action:
******* CommandLine: **********
MSI (c) (24:E0) [13:49:42:311]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (24:E0) [13:49:42:311]: Grabbed execution mutex.
MSI (c) (24:E0) [13:49:42:311]: Cloaking enabled.
MSI (c) (24:E0) [13:49:42:311]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (24:E0) [13:49:42:311]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (20:34) [13:49:42:342]: Grabbed execution mutex.
MSI (s) (20:C0) [13:49:42:342]: Resetting cached policy values
MSI (s) (20:C0) [13:49:42:342]: Machine policy value 'Debug' is 0
MSI (s) (20:C0) [13:49:42:342]: ******* RunEngine:
******* Product: {90032DD0-ABEE-4424-AC1E-B076BDD4E350}
******* Action:
******* CommandLine: **********
MSI (s) (20:C0) [13:49:42:342]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (20:C0) [13:49:42:342]: End dialog not enabled
MSI (s) (20:C0) [13:49:42:342]: Original package ==> C:\WINDOWS\Installer\64a9b.msi
MSI (s) (20:C0) [13:49:42:342]: Package we're running from ==> C:\WINDOWS\Installer\64a9b.msi
MSI (s) (20:C0) [13:49:42:420]: APPCOMPAT: looking for appcompat database entry with ProductCode '{90032DD0-ABEE-4424-AC1E-B076BDD4E350}'.
MSI (s) (20:C0) [13:49:42:420]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (20:C0) [13:49:42:420]: MSCOREE not loaded loading copy from system32
MSI (s) (20:C0) [13:49:42:436]: Opening existing patch 'C:\WINDOWS\Installer\129315a9.msp'.
MSI (s) (20:C0) [13:49:42:436]: Opening existing patch 'C:\WINDOWS\Installer\108ce01d.msp'.
MSI (s) (20:C0) [13:49:42:436]: File will have security applied from OpCode.
MSI (s) (20:C0) [13:49:46:264]: Original patch ==> d:\65d5346c9964167a51a661fd7445\HotFixTools\Files\sqlrun_tools.msp
MSI (s) (20:C0) [13:49:46:264]: Patch we're running from ==> C:\WINDOWS\Installer\4f74b2.msp
MSI (s) (20:C0) [13:49:46:264]: SOFTWARE RESTRICTION POLICY: Verifying patch --> 'd:\65d5346c9964167a51a661fd7445\HotFixTools\Files\sqlrun_tools.msp' against software restriction policy
MSI (s) (20:C0) [13:49:46:264]: Note: 1: 2262 2: DigitalSignature 3: -2147287038
MSI (s) (20:C0) [13:49:46:264]: SOFTWARE RESTRICTION POLICY: d:\65d5346c9964167a51a661fd7445\HotFixTools\Files\sqlrun_tools.msp is not digitally signed
MSI (s) (20:C0) [13:49:46:264]: SOFTWARE RESTRICTION POLICY: d:\65d5346c9964167a51a661fd7445\HotFixTools\Files\sqlrun_tools.msp is permitted to run at the 'unrestricted' authorization level.
MSI (s) (20:C0) [13:49:46:264]: SequencePatches starts. Product code: {90032DD0-ABEE-4424-AC1E-B076BDD4E350}, Product version: 9.00.1399.06, Upgrade code: {FED8B2D9-159B-41B0-826C-E3E0F8ADE264}, Product language 1033
MSI (s) (20:C0) [13:49:46:264]: 3.0 patch {223FBE1F-FD3F-4039-9521-AA218BD7BBAF} of type minor upgrade takes product {4D2DFB70-AECB-47BF-A895-3B3AA544934F} to version 9.2.3042.00
MSI (s) (20:C0) [13:49:46:264]: 3.0 patch {88591C3A-E392-4B2C-98B7-F123862FD540} of type minor upgrade takes product {7C498DA7-6C3B-4D8B-804F-FBCFF19612D4} to version 9.2.3042.00
MSI (s) (20:C0) [13:49:46:264]: 3.0 patch d:\65d5346c9964167a51a661fd7445\HotFixTools\Files\sqlrun_tools.msp of type minor upgrade takes product {4D2DFB70-AECB-47BF-A895-3B3AA544934F} to version 9.3.4035.00
MSI (s) (20:C0) [13:49:46:264]: PATCH SEQUENCER: verifying the applicability of minor upgrade patch {223FBE1F-FD3F-4039-9521-AA218BD7BBAF} against product code: {90032DD0-ABEE-4424-AC1E-B076BDD4E350}, product version: 9.00.1399.06, product language 1033 and upgrade code: {FED8B2D9-159B-41B0-826C-E3E0F8ADE264}
MSI (s) (20:C0) [13:49:46:264]: Validating transform 'Target01ToUpgrade01' with validation bits 0x920
MSI (s) (20:C0) [13:49:46:264]: Transform 'Target01ToUpgrade01' is valid.
MSI (s) (20:C0) [13:49:46:279]: Note: 1: 2262 2: _Tables 3: -2147287038
MSI (s) (20:C0) [13:49:46:279]: Note: 1: 2262 2: _Columns 3: -2147287038
MSI (s) (20:C0) [13:49:46:279]: PATCH SEQUENCER: minor upgrade patch {223FBE1F-FD3F-4039-9521-AA218BD7BBAF} is applicable.
MSI (s) (20:C0) [13:49:46:279]: PATCH SEQUENCER: verifying the applicability of minor upgrade patch {88591C3A-E392-4B2C-98B7-F123862FD540} against product code: {90032DD0-ABEE-4424-AC1E-B076BDD4E350}, product version: 9.00.1399.06, product language 1033 and upgrade code: {FED8B2D9-159B-41B0-826C-E3E0F8ADE264}
MSI (s) (20:C0) [13:49:46:279]: Validating transform 'Target01ToUpgrade01' with validation bits 0x920
MSI (s) (20:C0) [13:49:46:279]: Note: 1: 2760 2: Target01ToUpgrade01 3: C:\WINDOWS\Installer\129315a9.msp 4: {929C9FEC-8873-4A1A-A209-9AF432E8E1D1} 5: {FED8B2D9-159B-41B0-826C-E3E0F8ADE264}
MSI (s) (20:C0) [13:49:46:279]: 1: 2760 2: Target01ToUpgrade01 3: C:\WINDOWS\Installer\129315a9.msp 4: {929C9FEC-8873-4A1A-A209-9AF432E8E1D1} 5: {FED8B2D9-159B-41B0-826C-E3E0F8ADE264}
MSI (s) (20:C0) [13:49:46:279]: PATCH SEQUENCER: minor upgrade patch {88591C3A-E392-4B2C-98B7-F123862FD540} is not applicable.
MSI (s) (20:C0) [13:49:46:279]: PATCH SEQUENCER: verifying the applicability of minor upgrade patch d:\65d5346c9964167a51a661fd7445\HotFixTools\Files\sqlrun_tools.msp against product code: {90032DD0-ABEE-4424-AC1E-B076BDD4E350}, product version: 9.00.1399.06, product language 1033 and upgrade code: {FED8B2D9-159B-41B0-826C-E3E0F8ADE264}
MSI (s) (20:C0) [13:49:46:279]: Validating transform 'Target01ToUpgrade01' with validation bits 0x920
MSI (s) (20:C0) [13:49:46:279]: Transform 'Target01ToUpgrade01' is valid.
MSI (s) (20:C0) [13:49:46:295]: Note: 1: 2262 2: _Tables 3: -2147287038
MSI (s) (20:C0) [13:49:46:295]: Note: 1: 2262 2: _Columns 3: -2147287038
MSI (s) (20:C0) [13:49:46:295]: PATCH SEQUENCER: minor upgrade patch d:\65d5346c9964167a51a661fd7445\HotFixTools\Files\sqlrun_tools.msp is applicable.
MSI (s) (20:C0) [13:49:46:295]: SequencePatches returns success.
MSI (s) (20:C0) [13:49:46:295]: Final Patch Application Order:
MSI (s) (20:C0) [13:49:46:295]: {6C21427B-DF99-44EE-B019-C983DFC15964} - d:\65d5346c9964167a51a661fd7445\HotFixTools\Files\sqlrun_tools.msp
MSI (s) (20:C0) [13:49:46:295]: Other Patches:
MSI (s) (20:C0) [13:49:46:295]: Superseded: {22C72591-3BA4-4653-9215-10F9C6908416} -
MSI (s) (20:C0) [13:49:46:295]: Superseded: {71E59621-72C0-4987-B3BD-A5E3E48F8627} -
MSI (s) (20:C0) [13:49:46:295]: Superseded: {223FBE1F-FD3F-4039-9521-AA218BD7BBAF} -
MSI (s) (20:C0) [13:49:46:295]: Unknown\Absent: {88591C3A-E392-4B2C-98B7-F123862FD540} -
MSI (s) (20:C0) [13:49:46:295]: Machine policy value 'DisablePatch' is 0
MSI (s) (20:C0) [13:49:46:295]: Machine policy value 'AllowLockdownPatch' is 0
MSI (s) (20:C0) [13:49:46:295]: Machine policy value 'DisableLUAPatching' is 0
MSI (s) (20:C0) [13:49:46:295]: Disallowing uninstallation of patch {88591C3A-E392-4B2C-98B7-F123862FD540} because the patch is marked as not uninstallable
MSI (s) (20:C0) [13:49:46:295]: Product: Microsoft SQL Server 2005 Tools - Update 'Service Pack 2 for SQL Server Tools and Workstation Components 2005 ENU (KB921896)' could not be removed. Error code 1646. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB955706_sqlrun_tools.msp.log.
MSI (s) (20:C0) [13:49:46:310]: Product: Microsoft SQL Server 2005 Tools - Update '{6C21427B-DF99-44EE-B019-C983DFC15964}' could not be installed. Error code 1646. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB955706_sqlrun_tools.msp.log.
MSI (s) (20:C0) [13:49:46:310]: Note: 1: 1708
MSI (s) (20:C0) [13:49:46:310]: Note: 1: 2729
MSI (s) (20:C0) [13:49:46:310]: Note: 1: 2729
MSI (s) (20:C0) [13:49:46:310]: Product: Microsoft SQL Server 2005 Tools -- Installation failed.
MSI (s) (20:C0) [13:49:46:342]: Attempting to delete file C:\WINDOWS\Installer\4f74b2.msp
MSI (s) (20:C0) [13:49:46:342]: MainEngineThread is returning 1646
Uninstallation of the patch package is not supported.
C:\WINDOWS\Installer\64a9b.msi
MSI (c) (24:E0) [13:49:46:357]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (24:E0) [13:49:46:357]: MainEngineThread is returning 1646
=== Verbose logging stopped: 16/10/2009 13:49:46 ===
[/font]
October 15, 2009 at 9:57 pm
Fixed it!
Thanks to these links:
http://kb.acresso.com/selfservice/viewContent.do?externalID=Q105971
The file missing from C:\Windows\Installer\ was "4f74b2.msp"
And I had restored the incorrect version of sqlrun_tools.msp for: "129315a9.msp"
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply