Re: SQL server 2005 SP2 failing on cluster

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


"Geoff N. Hiten" wrote:

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


"Julien" <Julien@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CABECE51-5E20-4A5C-ABD3-50A62BCE1456@xxxxxxxxxxxxxxxx
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?
.

Relevant Pages

  • Re: SQL server 2005 SP2 failing on cluster
    ... 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'm having problem to update my SQL cluster with SQL server 2005 SP2. ... Package Platform: x86 ... see Help and Support Center at ...
    (microsoft.public.sqlserver.clustering)
  • Re: Tiger Stock
    ... a lot of money selling applications based on their own platform. ... larger players support more interfaces, ... Coming back to a point in the last paragraph: Lack of support for SQL ... So if we take that off the table and compare companies, ...
    (comp.databases.pick)
  • RE: SQL Set to System Account - Sharepoint Question
    ... Administration", not System Account) account. ... after the installation there isn't normally any reason to ... SQL, don't use an instance being used for anything else. ... the App Support people why SA is required. ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Mobile and Datasets Problem
    ... About the database question, in the sql server 2005 table that is used to replicate with the mobile database, i put the flag rowguid to false in the uniqueidentifier primary key. ... Can i use the sql server 2005 tables for RDA replication without any identity columns defined? ... If you'd like to know more details about this, I recommend that you open a Support incident with Microsoft Customer Support Services so that a dedicated Support Professional can work with you in a more timely and efficient manner. ...
    (microsoft.public.sqlserver.replication)
  • Re: sqlstring -- a library to build a SELECT statement
    ... > short-circuiting behaviors regarding them (the resultant bytecode will ... How to best add further sql function support? ... > database does not support a given function (or operator, ... > case-insensitive in MS SQL Server but case-sensitive in PostgreSQL). ...
    (comp.lang.python)