Hi all,

I'm having problem to update my SQL cluster with SQL server 2005 SP2.
Here is the summary log:

Time: 04/13/2007 18:47:03.120
KB Number: KB921896
Machine: FRESHCLUSTSQL01
OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service
Pack 2 (Build 3790)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: Yes
Log Location on Passive Nodes:
(FRESHCLUSTSQL01) C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix
(FRESHCLUSTSQL02) C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Detected Language Level Patch Level
Platform Edition
Setup Support Files ENU 9.2.3042
x86
Database Services (MSSQLSERVER) ENU SP2 2005.090.3042.00
x86 STANDARD
SQL Server Native Client ENU 9.00.3042.00
x86
Client Components ENU SP1 9.1.2047
x86 STANDARD
MSXML 6.0 Parser ENU 6.10.1129.0
x86
SQLXML4 ENU 9.00.3042.00
x86
Backward Compatibility ENU 8.05.2004
x86
Microsoft SQL Server VSS Writer 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 : Setup Support Files
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_SqlSupport.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 3042
Product Version (Final) :
Status : Failure
Log File :
Error Number : 11009
Error Description : No passive nodes were successfully patched
----------------------------------------------------------------------------------
Product : SQL Server Native Client
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_sqlncli.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Client Components
Product Version (Previous): 2047
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log
Error Number : 29549
Error Description : MSP Error: 29549 Failed to install and
configure assemblies C:\Program Files\Microsoft SQL
Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: The Transaction Manager is not available. (Exception from
HRESULT: 0x8004D01B)
----------------------------------------------------------------------------------
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 :
----------------------------------------------------------------------------------
Product : Backward Compatibility
Product Version (Previous): 2004
Product Version (Final) : 2004
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SQLServer2005_BC.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Microsoft SQL Server VSS Writer
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_SqlWriter.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------

**********************************************************************************
Summary
No passive nodes were successfully patched
Exit Code Returned: 11009



Also, here are the few events failing (identical on both cluster nodes apart
from cluster name):

Event Type: Error
Event Source: COM+
Event Category: (98)
Event ID: 4691
Date: 13/04/2007
Time: 18:38:02
User: N/A
Computer: FRESHCLUSTSQL02
Description:
The run-time environment was unable to initialize for transactions required
to support transactional components. Make sure that MS-DTC is running.
(DtcGetTransactionManagerEx(): hr = 0x8004d01b)

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

-------------------------------------

Event Type: Error
Event Source: MsiInstaller
Event Category: None
Event ID: 1023
Date: 13/04/2007
Time: 18:39:28
User: FRESH\Administrator

Hmm. We have been told for a long time that MSDTC is optional on a cluster
but is all but required in the real world. I guess Microsoft finally built
a dependency on it. Install MSDTC on your cluster.
http://support.microsoft.com/kb/301600

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP


[quoted text, click to view]