Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Unable to install SQL Server 2005 Security Update Hotfix KB970895

Posted on 2010-09-13
15
Medium Priority
?
1,046 Views
Last Modified: 2012-05-10
Have tried many suggestions found online to install this patch, but it always fails.  Running SBS2003.  Here is the log:

=== Verbose logging started: 9/12/2010  3:01:45  Build type: SHIP UNICODE 3.01.4000.4042  Calling process: g:\ed26f91a3a884a35920e8dbf5e25\hotfix.exe ===
MSI (c) (68:7C) [03:01:45:716]: Resetting cached policy values
MSI (c) (68:7C) [03:01:45:716]: Machine policy value 'Debug' is 0
MSI (c) (68:7C) [03:01:45:716]: ******* RunEngine:
           ******* Product: {6C428277-232D-4CC2-90ED-A1DCFE7DF64F}
           ******* Action:
           ******* CommandLine: **********
MSI (c) (68:7C) [03:01:45:716]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (68:7C) [03:01:45:716]: Grabbed execution mutex.
MSI (c) (68:7C) [03:01:45:857]: Cloaking enabled.
MSI (c) (68:7C) [03:01:45:857]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (68:7C) [03:01:45:872]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (00:38) [03:01:45:903]: Grabbed execution mutex.
MSI (s) (00:1C) [03:01:45:903]: Resetting cached policy values
MSI (s) (00:1C) [03:01:45:903]: Machine policy value 'Debug' is 0
MSI (s) (00:1C) [03:01:45:903]: ******* RunEngine:
           ******* Product: {6C428277-232D-4CC2-90ED-A1DCFE7DF64F}
           ******* Action:
           ******* CommandLine: **********
MSI (s) (00:1C) [03:01:45:903]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (00:1C) [03:01:47:169]: End dialog not enabled
MSI (s) (00:1C) [03:01:47:169]: Original package ==> C:\WINDOWS\Installer\8b152.msi
MSI (s) (00:1C) [03:01:47:169]: Package we're running from ==> C:\WINDOWS\Installer\8b152.msi
MSI (s) (00:1C) [03:01:47:341]: APPCOMPAT: looking for appcompat database entry with ProductCode '{6C428277-232D-4CC2-90ED-A1DCFE7DF64F}'.
MSI (s) (00:1C) [03:01:47:341]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (00:1C) [03:01:47:419]: MSCOREE not loaded loading copy from system32
MSI (s) (00:1C) [03:01:47:466]: File will have security applied from OpCode.
MSI (s) (00:1C) [03:01:47:685]: Original patch ==> g:\ed26f91a3a884a35920e8dbf5e25\HotFixSQL\Files\sqlrun_sql.msp
MSI (s) (00:1C) [03:01:47:685]: Patch we're running from ==> C:\WINDOWS\Installer\9f96baab.msp
MSI (s) (00:1C) [03:01:47:732]: Opening existing patch 'C:\WINDOWS\Installer\76df6f2.msp'.
MSI (s) (00:1C) [03:01:51:497]: SequencePatches starts. Product code: {6C428277-232D-4CC2-90ED-A1DCFE7DF64F}, Product version: 9.2.3042.00, Upgrade code: {AD56D6A9-D61E-4F98-8D54-D6272E054CE6}, Product language 1033
MSI (s) (00:1C) [03:01:51:497]: 3.0 patch g:\ed26f91a3a884a35920e8dbf5e25\HotFixSQL\Files\sqlrun_sql.msp is of type QFE
MSI (s) (00:1C) [03:01:51:497]: PATCH SEQUENCER: verifying the applicability of QFE patch g:\ed26f91a3a884a35920e8dbf5e25\HotFixSQL\Files\sqlrun_sql.msp against product code: {6C428277-232D-4CC2-90ED-A1DCFE7DF64F}, product version: 9.2.3042.00, product language 1033 and upgrade code: {AD56D6A9-D61E-4F98-8D54-D6272E054CE6}
MSI (s) (00:1C) [03:01:51:513]: Validating transform 'Target01ToUpgrade01' with validation bits 0x920
MSI (s) (00:1C) [03:01:51:513]: Note: 1: 2760 2: Target01ToUpgrade01 3: C:\WINDOWS\Installer\76df6f2.msp 4: {929C9FEC-8873-4A1A-A209-9AF432E8E1D1} 5: {AD56D6A9-D61E-4F98-8D54-D6272E054CE6}
MSI (s) (00:1C) [03:01:51:513]: 1: 2760 2: Target01ToUpgrade01 3: C:\WINDOWS\Installer\76df6f2.msp 4: {929C9FEC-8873-4A1A-A209-9AF432E8E1D1} 5: {AD56D6A9-D61E-4F98-8D54-D6272E054CE6}
MSI (s) (00:1C) [03:01:51:513]: PATCH SEQUENCER: QFE patch g:\ed26f91a3a884a35920e8dbf5e25\HotFixSQL\Files\sqlrun_sql.msp is not applicable.
MSI (s) (00:1C) [03:01:51:513]: SequencePatches returns success.
MSI (s) (00:1C) [03:01:51:513]: Final Patch Application Order:
MSI (s) (00:1C) [03:01:51:513]: Other Patches:
MSI (s) (00:1C) [03:01:51:513]: Unknown\Absent: {AB73742E-F661-44DF-8652-0B13191943ED} - g:\ed26f91a3a884a35920e8dbf5e25\HotFixSQL\Files\sqlrun_sql.msp
MSI (s) (00:1C) [03:01:51:513]: Product: Microsoft SQL Server 2005 Express Edition - Update '{AB73742E-F661-44DF-8652-0B13191943ED}' could not be installed. Error code 1642. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB970895_sqlrun_sql.msp.log.

MSI (s) (00:1C) [03:01:51:528]: Note: 1: 1708
MSI (s) (00:1C) [03:01:51:528]: Note: 1: 2729
MSI (s) (00:1C) [03:01:51:591]: Note: 1: 2729
MSI (s) (00:1C) [03:01:51:591]: Product: Microsoft SQL Server 2005 Express Edition -- Installation failed.

MSI (s) (00:1C) [03:01:51:591]: Attempting to delete file C:\WINDOWS\Installer\9f96baab.msp
MSI (s) (00:1C) [03:01:51:607]: MainEngineThread is returning 1642

Many thanks.

Steve
0
Comment
Question by:sgarson1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 10
  • 5
15 Comments
 
LVL 20

Expert Comment

by:Marten Rune
ID: 33670175
Quote: "Additional information is available in the log file C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB970895_sqlrun_sql.msp.log"

Can we see this please

//Marten
0
 

Author Comment

by:sgarson1
ID: 33671222
This is the file referenced, but it appears to be the same as what I pasted above.


=== Verbose logging started: 9/13/2010  3:01:40  Build type: SHIP UNICODE 3.01.4000.4042  Calling process: g:\1cd7832f56cae8b24608815832\hotfix.exe ===
MSI (c) (E4:58) [03:01:40:610]: Resetting cached policy values
MSI (c) (E4:58) [03:01:40:610]: Machine policy value 'Debug' is 0
MSI (c) (E4:58) [03:01:40:610]: ******* RunEngine:
           ******* Product: {6C428277-232D-4CC2-90ED-A1DCFE7DF64F}
           ******* Action:
           ******* CommandLine: **********
MSI (c) (E4:58) [03:01:40:641]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (E4:58) [03:01:40:657]: Grabbed execution mutex.
MSI (c) (E4:58) [03:01:40:829]: Cloaking enabled.
MSI (c) (E4:58) [03:01:40:829]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (E4:58) [03:01:40:844]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (84:00) [03:01:40:891]: Grabbed execution mutex.
MSI (s) (84:E0) [03:01:40:907]: Resetting cached policy values
MSI (s) (84:E0) [03:01:40:907]: Machine policy value 'Debug' is 0
MSI (s) (84:E0) [03:01:40:907]: ******* RunEngine:
           ******* Product: {6C428277-232D-4CC2-90ED-A1DCFE7DF64F}
           ******* Action:
           ******* CommandLine: **********
MSI (s) (84:E0) [03:01:40:907]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (84:E0) [03:01:42:532]: End dialog not enabled
MSI (s) (84:E0) [03:01:42:547]: Original package ==> C:\WINDOWS\Installer\8b152.msi
MSI (s) (84:E0) [03:01:42:547]: Package we're running from ==> C:\WINDOWS\Installer\8b152.msi
MSI (s) (84:E0) [03:01:42:735]: APPCOMPAT: looking for appcompat database entry with ProductCode '{6C428277-232D-4CC2-90ED-A1DCFE7DF64F}'.
MSI (s) (84:E0) [03:01:42:750]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (84:E0) [03:01:42:813]: MSCOREE not loaded loading copy from system32
MSI (s) (84:E0) [03:01:42:922]: File will have security applied from OpCode.
MSI (s) (84:E0) [03:01:43:407]: Original patch ==> g:\1cd7832f56cae8b24608815832\HotFixSQL\Files\sqlrun_sql.msp
MSI (s) (84:E0) [03:01:43:407]: Patch we're running from ==> C:\WINDOWS\Installer\a4bd04a9.msp
MSI (s) (84:E0) [03:01:43:485]: Opening existing patch 'C:\WINDOWS\Installer\76df6f2.msp'.
MSI (s) (84:E0) [03:01:46:516]: SequencePatches starts. Product code: {6C428277-232D-4CC2-90ED-A1DCFE7DF64F}, Product version: 9.2.3042.00, Upgrade code: {AD56D6A9-D61E-4F98-8D54-D6272E054CE6}, Product language 1033
MSI (s) (84:E0) [03:01:46:532]: 3.0 patch g:\1cd7832f56cae8b24608815832\HotFixSQL\Files\sqlrun_sql.msp is of type QFE
MSI (s) (84:E0) [03:01:46:532]: PATCH SEQUENCER: verifying the applicability of QFE patch g:\1cd7832f56cae8b24608815832\HotFixSQL\Files\sqlrun_sql.msp against product code: {6C428277-232D-4CC2-90ED-A1DCFE7DF64F}, product version: 9.2.3042.00, product language 1033 and upgrade code: {AD56D6A9-D61E-4F98-8D54-D6272E054CE6}
MSI (s) (84:E0) [03:01:46:532]: Validating transform 'Target01ToUpgrade01' with validation bits 0x920
MSI (s) (84:E0) [03:01:46:532]: Note: 1: 2760 2: Target01ToUpgrade01 3: C:\WINDOWS\Installer\76df6f2.msp 4: {929C9FEC-8873-4A1A-A209-9AF432E8E1D1} 5: {AD56D6A9-D61E-4F98-8D54-D6272E054CE6}
MSI (s) (84:E0) [03:01:46:532]: 1: 2760 2: Target01ToUpgrade01 3: C:\WINDOWS\Installer\76df6f2.msp 4: {929C9FEC-8873-4A1A-A209-9AF432E8E1D1} 5: {AD56D6A9-D61E-4F98-8D54-D6272E054CE6}
MSI (s) (84:E0) [03:01:46:532]: PATCH SEQUENCER: QFE patch g:\1cd7832f56cae8b24608815832\HotFixSQL\Files\sqlrun_sql.msp is not applicable.
MSI (s) (84:E0) [03:01:46:532]: SequencePatches returns success.
MSI (s) (84:E0) [03:01:46:532]: Final Patch Application Order:
MSI (s) (84:E0) [03:01:46:532]: Other Patches:
MSI (s) (84:E0) [03:01:46:532]: Unknown\Absent: {AB73742E-F661-44DF-8652-0B13191943ED} - g:\1cd7832f56cae8b24608815832\HotFixSQL\Files\sqlrun_sql.msp
MSI (s) (84:E0) [03:01:46:547]: Product: Microsoft SQL Server 2005 Express Edition - Update '{AB73742E-F661-44DF-8652-0B13191943ED}' could not be installed. Error code 1642. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB970895_sqlrun_sql.msp.log.

MSI (s) (84:E0) [03:01:46:547]: Note: 1: 1708
MSI (s) (84:E0) [03:01:46:547]: Note: 1: 2729
MSI (s) (84:E0) [03:01:46:641]: Note: 1: 2729
MSI (s) (84:E0) [03:01:46:641]: Product: Microsoft SQL Server 2005 Express Edition -- Installation failed.

MSI (s) (84:E0) [03:01:46:657]: Attempting to delete file C:\WINDOWS\Installer\a4bd04a9.msp
MSI (s) (84:E0) [03:01:46:657]: 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\8b152.msi
MSI (c) (E4:58) [03:01:46:672]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
MSI (c) (E4:58) [03:01:46:672]: MainEngineThread is returning 1642
=== Verbose logging stopped: 9/13/2010  3:01:46 ===

0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 20

Expert Comment

by:Marten Rune
ID: 33671497
What do you get if you run
select @@version in SSMSE

/Marten
0
 

Author Comment

by:sgarson1
ID: 33671644
I'm not sure how to access SSMSE.  My options are SQL Server Configuration Manager, Error and Usage Reporting, and Surface Area Configuration.  
0
 

Author Comment

by:sgarson1
ID: 33671664
I now see that SSME is an optional download.  Will try it.
0
 

Author Comment

by:sgarson1
ID: 33671801
select @@version

MS SQL Server 2005 9.00.0342
0
 

Author Comment

by:sgarson1
ID: 33673159
When I do the following:
Open the following folder:
%ProgramFiles%\Microsoft SQL Server\MSSQL.X\MSSQL
Right-click the Data folder, and then click Sharing and Security.
In the Properties dialog box, click the Security tab.
Under Group or user names, click Administrators.
Under Permissions for Administrators, click to select the Allow check box for the Full Control permission.
Click OK.
Open the Data folder.
On the Edit menu, click Select All.
On the File menu, click Properties.
In the Properties dialog box, click the Security tab.

The result is :  The permissions cannot be displayed because they are different between master.mdf and xxx-xxx-xxx.cer....Do you wish to reset the permissions on all the selected items?
0
 
LVL 20

Expert Comment

by:Marten Rune
ID: 33680222
At: http://www.krell-software.com/mssql-builds.asp you can see your version
I guess 'MS SQL Server 2005 9.00.0342' is really 'MS SQL Server 2005 9.00.3042'

Can it be a permissions issue.
Go to LogOn properties of SQL Server Service
Grant access at Local System account
Restart SQL Services
See if the package installs
If not try a reboot also
after this reset SQL Server Service Account to the one you used to have. (make sure you have this pwd before trying this).
0
 

Author Comment

by:sgarson1
ID: 33682742
Should I reset the permissions based on the message:  The permissions cannot be displayed because they are different between master.mdf and xxx-xxx-xxx.cer....Do you wish to reset the permissions on all the selected items?

The properties show the Local System account as the default login.

Also, is there any way for me to verify the password?  I set it four years ago and "think" I remember it.
0
 
LVL 20

Expert Comment

by:Marten Rune
ID: 33694424
Dont reset the permission. The xxx.cer file is special.

You can verify the password by opening a cmd prompt, and run the runas command. Lookat runas /? for the syntax.

//Marten
0
 

Accepted Solution

by:
sgarson1 earned 0 total points
ID: 33950792
Please cancel this question.  No answer worked.
0
 
LVL 20

Expert Comment

by:Marten Rune
ID: 33951342
Hope it's been fixed anyway, i e reinstall or something. By al means delete the question.

sqarson1, to bad you did not reply earliare that it wasn't working. I would have given it more effort.

//Marten
0
 

Author Comment

by:sgarson1
ID: 34284867
Gave up
0
 

Author Closing Comment

by:sgarson1
ID: 34324382
Honestly, I gave up getting it to work,
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question