Solved

Unable to install SQL Server 2005 Security Update Hotfix KB970895

Posted on 2010-09-13
15
1,025 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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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…
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…

830 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