Solved

Unable to install SQL Server 2005 Security Update Hotfix KB970895

Posted on 2010-09-13
15
1,021 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
  • 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
 

Author Comment

by:sgarson1
ID: 33671263
0
 
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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
I’m often asked about newer and larger USB drives connected to SBS2008 and 2011 failing Windows Server Backup vs the older USB drives not failing. As disk space continues to grow and drive technology change SBS2008 and some SBS2011 end up with the f…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

708 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now