 |
SQL server 2005 SP2 failing on cluster - Julie |
17-Apr-07 02:18:02
|
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
Computer: FRESHCLUSTSQL02
Description:
Product: Microsoft SQL Server 2005 Tools - Update 'Service Pack 2 for SQL
Server Tools and Workstation Components 2005 ENU (KB921896)' could not be
installed. Error code 1603. Additional information is available in the log
file C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 7b 31 44 44 34 36 33 43 {1DD463C
0008: 30 2d 41 35 30 41 2d 34 0-A50A-4
0010: 33 39 34 2d 42 37 45 34 394-B7E4
0018: 2d 35 38 39 35 43 30 32 -5895C02
0020: 46 39 45 30 44 7d 20 7b F9E0D} {
0028: 38 38 35 39 31 43 33 41 88591C3A
0030: 2d 45 33 39 32 2d 34 42 -E392-4B
0038: 32 43 2d 39 38 42 37 2d 2C-98B7-
0040: 46 31 32 33 38 36 32 46 F123862F
0048: 44 35 34 30 7d 20 31 36 D540} 16
0050: 30 33 03
---------------------------------------
Event Type: Error
Event Source: COM+
Event Category: (98)
Event ID: 4691
Date: 13/04/2007
Time: 18:41:38
User: N/A
Computer: FRESHCLUSTSQL01
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: 10005
Date: 13/04/2007
Time: 18:41:38
User: FRESH\Administrator
Computer: FRESHCLUSTSQL01
Description:
Product: Microsoft SQL Server 2005 Tools -- 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)
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 7b 31 44 44 34 36 33 43 {1DD463C
0008: 30 2d 41 35 30 41 2d 34 0-A50A-4
0010: 33 39 34 2d 42 37 45 34 394-B7E4
0018: 2d 35 38 39 35 43 30 32 -5895C02
0020: 46 39 45 30 44 7d F9E0D}
---------------------------------------
Event Type: Error
Event Source: MsiInstaller
Event Category: None
Event ID: 1023
Date: 13/04/2007
Time: 18:43:03
User: FRESH\Administrator
Computer: FRESHCLUSTSQL01
Description:
Product: Microsoft SQL Server 2005 Tools - Update 'Service Pack 2 for SQL
Server Tools and Workstation Components 2005 ENU (KB921896)' could not be
installed. Error code 1603. Additional information is available in the log
file C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 7b 31 44 44 34 36 33 43 {1DD463C
0008: 30 2d 41 35 30 41 2d 34 0-A50A-4
0010: 33 39 34 2d 42 37 45 34 394-B7E4
0018: 2d 35 38 39 35 43 30 32 -5895C02
0020: 46 39 45 30 44 7d 20 7b F9E0D} {
0028: 38 38 35 39 31 43 33 41 88591C3A
0030: 2d 45 33 39 32 2d 34 42 -E392-4B
0038: 32 43 2d 39 38 42 37 2d 2C-98B7-
0040: 46 31 32 33 38 36 32 46 F123862F
0048: 44 35 34 30 7d 20 31 36 D540} 16
0050: 30 33 03
I looked at the particular hotfixes logs (too big to post here) and couldn't
find anything that was properly talking to me.
Any ideas what it could come from?
Thanks for your help
Julien |
 |
| |
| |
|
| |
|
SQL server 2005 SP2 failing on cluster - Geoff N. Hiten |
17-Apr-07 04:39:56
|
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 |
| |
| |
SQL server 2005 SP2 failing on cluster - Julie |
18-Apr-07 12:14:04
|
Hi Geoff,
Thanks again for your reply.
My MSDTC was already setup but I don't know why the DTC resource wasn't.
Once added and online, it worked like a charm.
Thanks again,
Julien |
| |
| |
|
|
| Microsoft SQL Server 2005 disappears on one node. |