Re: Unable to Install SQL2005 SP2

Chris,

Below is the summary.txt from the Hotfix folder. As you will see, the setup
could only detected two products MSXML 6.0 Parser and SQLXML4. Thanks in
advance!

Henry

Time: 04/04/2007 12:04:50.383
KB Number: KB921896
Machine: G1DSQL20
OS Version: Microsoft Windows 2000 Advanced Server Service Pack 4 (Build 2195)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: No

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Failed

**********************************************************************************
Products Detected Language Level Patch Level
Platform Edition
MSXML 6.0 Parser ENU 6.10.1129.0
x86
SQLXML4 ENU 9.00.3042.00
x86

**********************************************************************************
Products Disqualified & Reason
Product Reason

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name
PID

**********************************************************************************
Product Installation Status
Product : MSXML 6.0 Parser
Product Version (Previous): 1129
Product Version (Final) : 6.10.1129.0
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_msxml6.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQLXML4
Product Version (Previous): 3042
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_sqlxml4.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------

**********************************************************************************
Summary
Success
Exit Code Returned: 0



"Chris Wood" wrote:

Henry,

What we need to look at is the Summary_?.txt file in C:\Program
Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix folder. The ? will
be either 0,1,2 or nothing. This is the result of the upgrade. Inside it
will be the section on the failed component upgrade.

Chris

"HenryT" <HenryT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4A0383C1-675A-460F-8973-125861196205@xxxxxxxxxxxxxxxx
Chris,

Thank you for replying quickly! The SP2 installation only showed status
"success" for MSXML 6.0 Parser ans SQLXML4. I include the SP2
installation
log for your review. Please let me know if there's other logs that can be
helpful. I tried to include the install log in this reply but is is too
big.
The log file name is at "C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_msxml6.msi.log". I opened
thislog file and didnot find any occurences of "error" . There's one
ocurrence of "fail" whic is shown below:
==========
Property(S): SupportedOSMessage = Installation of this product failed
because it is not supported on this operating system. For information on
supported configurations, see the product documentation.
==========

Thank you so much for your help!
Henry


"Chris Wood" wrote:

Henry,

Do you have the log of the error? We might be able to help given that
info.

Chris

"HenryT" <HenryT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C8A854D4-9549-485D-9281-17E5E8DE08B6@xxxxxxxxxxxxxxxx
I was not able to apply SQL2005 SP2 to a SQL2005 box with SP1 plus
cumulative
hot fix package SQL2005-kb918222. If anyone has the answer, please
help.
Below is information regarding this server:
1. Installed SQL2005 with two instances
2. Applied SQL 2005 SP1 without any problems. Product name is
SQLServer2005SP1-KB913090-x86-ENU.exe
3. Applied cumulative hotfix packages (Build 2153) including
sql2005-kb918222-x86-enu.exe, as2005-kb918222-x86-enu.exe,
dts2005-kb918222-x86-enu.exe, ns2005-kb918222-x86-enu.exe,
rs2005-kb918222-x86-enu.exe, sqltools2005-kb918222-x86-enu.exe
4. Tried to apply SQL2005 SP2 but FAILED.
5. Current version of SQL2005 server is 9.0.2153

I also discovered the following problems after applying hotfix package:
- SS Configuration Manager doesn't show any services even all SQL
services
started fine.
- Surface Area Config tool doesn't see any SQL components
- "Add or Remove Program" can not uninstall any of the hotfixes KB91822
- SP2 Install Wizard doesn't list all services for update. It lists
only
MSXML 6.0 Parser ans SQLXML4

For servers without SP1 and Hotfixes, SP2 was applied without any
problems.
Thanks in advance for any help!






.

Relevant Pages

  • Re: DTS Tasks running in job random failure
    ... think that SQL 2000 SP4 includes that hotfix? ... > Hi Scott ... Microsoft Data Transformation Services Package ...
    (microsoft.public.sqlserver.dts)
  • Re: Unable to Install SQL2005 SP2
    ... I believe I used the right package because it worked with other SQL2005 ... the Hotfix package KB918222. ... The SQL Support: ... Product Installation Status ...
    (microsoft.public.sqlserver.setup)
  • Re: Unable to Install SQL2005 SP2
    ... The SQL Support: ... Are you trying to upgrade with the right ... Package Language: 1033 ... Product Installation Status ...
    (microsoft.public.sqlserver.setup)
  • Re: Removing a SQL cluster node
    ... This will NOT take the instance offline but may ... This will also take the instance offline during the installation. ... Microsoft SQL Server MVP ... > 'hotfix' I am talking about running the SQL 2000 installation CD setup ...
    (microsoft.public.sqlserver.clustering)
  • SQL Server 2005 Express Ed (KB 921896): errorcode 0x65B
    ... The automatic update of my MS SQL Server 2005 Express ... The log file summary.txt at C:\Program Files\Microsoft SQL Server\90\Setup ... Package Language: 1043 ... Product Installation Status ...
    (microsoft.public.windowsupdate)
Loading