Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1067
  • Last Modified:

Unable to install SQL Server 2005 Security Update Hotfix KB970895

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
sgarson1
Asked:
sgarson1
  • 10
  • 5
1 Solution
 
Marten RuneSQL Expert/Infrastructure ArchitectCommented:
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
 
sgarson1Author Commented:
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
 
sgarson1Author Commented:
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Marten RuneSQL Expert/Infrastructure ArchitectCommented:
What do you get if you run
select @@version in SSMSE

/Marten
0
 
sgarson1Author Commented:
I'm not sure how to access SSMSE.  My options are SQL Server Configuration Manager, Error and Usage Reporting, and Surface Area Configuration.  
0
 
sgarson1Author Commented:
I now see that SSME is an optional download.  Will try it.
0
 
sgarson1Author Commented:
select @@version

MS SQL Server 2005 9.00.0342
0
 
sgarson1Author Commented:
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
 
Marten RuneSQL Expert/Infrastructure ArchitectCommented:
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
 
sgarson1Author Commented:
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
 
Marten RuneSQL Expert/Infrastructure ArchitectCommented:
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
 
sgarson1Author Commented:
Please cancel this question.  No answer worked.
0
 
Marten RuneSQL Expert/Infrastructure ArchitectCommented:
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
 
sgarson1Author Commented:
Gave up
0
 
sgarson1Author Commented:
Honestly, I gave up getting it to work,
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 10
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now