Can not bring MSDTC online in W2K3EE-SP1 cluster (2 nodes)

I've installed Windows Server 2003 EE SP1 Cluster successfully with two nodes
and now I'm trying to install MS SQL server 2000 Cluster on it..
as part of the preparation is to add new resource for MSDTC before install
SQL server 2000 then upgrade to sql server 2000 sp3a..
I've used two methods to add MSDTC resource to the cluster ... one by using
the Cluster resources Quorum disk and ip address... and the second time using
special ip and disk for MSDTC different than the quorum and add in separate
group.. but in both methods the same error msdtc resource failed..
errors in event log:
=================================
application log: eventid 4383
MS DTC was unable to determine the state of the cluster service on this
machine. MS DTC cannot continue to startup. Please contact Microsoft Product
Support. Error Specifics:
d:\srvrtm\com\complus\dtc\shared\mtxclu\mtxclusetu phelper.cpp:498, Pid: 2636,
CmdLine: C:\WINOS\system32\msdtc.exe
===========================================
in the security log: eventid 560
Object Open:
Object Server: SC Manager
Object Type: SERVICE OBJECT
Object Name: ClusSvc
Handle ID: -
Operation ID: {0,27022083}
Process ID: 632
Image File Name: C:\WINOS\system32\services.exe
Primary User Name: Q4A-DEV$
Primary Domain: IAEA
Primary Logon ID: (0x0,0x3E7)
Client User Name: NETWORK SERVICE
Client Domain: NT AUTHORITY
Client Logon ID: (0x0,0x3E4)
Accesses: READ_CONTROL
Query service configuration information
Query status of service
Enumerate dependencies of service
Query information from service
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x2008D
========================================
in the system log
eventid 7034
The Distributed Transaction Coordinator service terminated unexpectedly. It
has done this 1 time(s).
======================================
Please let me know how to resolve it..
I've used as well the method in http://support.microsoft.com/kb/301600/en-us
but the same result..
I was reading the news and found that many have troubles during the
installation because the sql server 2000 EE doesn't contain sp3a and in many
cases it failed to continue with the installation on W2K3EESP1 in the process
before the upgrade to sp3a...
how to fix the msdtc problem in the cluster !!!?
Thanks
best regards,
Samo
Sounds like a permissions issue based on the info you posted. Check the
startup account for the MSDTC service on each node. Make sure it is a
domain-level account that has admin priviledges on the box. I generally use
the cluster service account for the MSDTC account to avoid any permissions
issues.
Geoff N. Hiten
Microsoft SQL Server MVP
"Samo" <Samo@.discussions.microsoft.com> wrote in message
news:1EF209B9-9074-4D0E-899E-25C46865BF52@.microsoft.com...
> I've installed Windows Server 2003 EE SP1 Cluster successfully with two
> nodes
> and now I'm trying to install MS SQL server 2000 Cluster on it..
> as part of the preparation is to add new resource for MSDTC before install
> SQL server 2000 then upgrade to sql server 2000 sp3a..
> I've used two methods to add MSDTC resource to the cluster ... one by
> using
> the Cluster resources Quorum disk and ip address... and the second time
> using
> special ip and disk for MSDTC different than the quorum and add in
> separate
> group.. but in both methods the same error msdtc resource failed..
> errors in event log:
> =================================
> application log: eventid 4383
> MS DTC was unable to determine the state of the cluster service on this
> machine. MS DTC cannot continue to startup. Please contact Microsoft
> Product
> Support. Error Specifics:
> d:\srvrtm\com\complus\dtc\shared\mtxclu\mtxclusetu phelper.cpp:498, Pid:
> 2636,
> CmdLine: C:\WINOS\system32\msdtc.exe
> ===========================================
> in the security log: eventid 560
> Object Open:
> Object Server: SC Manager
> Object Type: SERVICE OBJECT
> Object Name: ClusSvc
> Handle ID: -
> Operation ID: {0,27022083}
> Process ID: 632
> Image File Name: C:\WINOS\system32\services.exe
> Primary User Name: Q4A-DEV$
> Primary Domain: IAEA
> Primary Logon ID: (0x0,0x3E7)
> Client User Name: NETWORK SERVICE
> Client Domain: NT AUTHORITY
> Client Logon ID: (0x0,0x3E4)
> Accesses: READ_CONTROL
> Query service configuration information
> Query status of service
> Enumerate dependencies of service
> Query information from service
> Privileges: -
> Restricted Sid Count: 0
> Access Mask: 0x2008D
> ========================================
> in the system log
> eventid 7034
> The Distributed Transaction Coordinator service terminated unexpectedly.
> It
> has done this 1 time(s).
> ======================================
> Please let me know how to resolve it..
> I've used as well the method in
> http://support.microsoft.com/kb/301600/en-us
> but the same result..
> I was reading the news and found that many have troubles during the
> installation because the sql server 2000 EE doesn't contain sp3a and in
> many
> cases it failed to continue with the installation on W2K3EESP1 in the
> process
> before the upgrade to sp3a...
> how to fix the msdtc problem in the cluster !!!?
> Thanks
> --
> best regards,
> Samo
|||I've just spent two days trying to get SQL2K on a W2kEE (no sp1)
cluster.
My first problem was getting the MSDTC to come online. I could
configure it but not get it online.
I tried all the MS suggestions and more besides including
uninstall/reinstall MSDTC. In a vain attempt to get it working I ended
up breaking the cluster service, it refused to start.
My solution was to rebuild the server, setup my cluster group for
network/quorom, then before setting up DTC group, make registry change
for the Clusterinstallstate, enable network DTC and it worked first
time.
Sorry I couldn't give you a quick fix. I've still got to fix my
installation failure - unable to install SQL on a 2nd node.
Steve
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message news:<eDd30kSTFHA.3392@.TK2MSFTNGP12.phx.gbl>...[vbcol=seagreen]
> Sounds like a permissions issue based on the info you posted. Check the
> startup account for the MSDTC service on each node. Make sure it is a
> domain-level account that has admin priviledges on the box. I generally use
> the cluster service account for the MSDTC account to avoid any permissions
> issues.
> Geoff N. Hiten
> Microsoft SQL Server MVP
>
> "Samo" <Samo@.discussions.microsoft.com> wrote in message
> news:1EF209B9-9074-4D0E-899E-25C46865BF52@.microsoft.com...
|||I've used the Cluster service account which has local admin rights, log on as
service, etc on both nodes but the same application eventid 4383 error
persist and msdtc failed to start ...
best regards,
Samo
"Geoff N. Hiten" wrote:

> Sounds like a permissions issue based on the info you posted. Check the
> startup account for the MSDTC service on each node. Make sure it is a
> domain-level account that has admin priviledges on the box. I generally use
> the cluster service account for the MSDTC account to avoid any permissions
> issues.
> Geoff N. Hiten
> Microsoft SQL Server MVP
>
> "Samo" <Samo@.discussions.microsoft.com> wrote in message
> news:1EF209B9-9074-4D0E-899E-25C46865BF52@.microsoft.com...
>
>
|||Just to let you know , the MSDTC resource started without problem after
using the cluster service account and "restarting the cluster service" which
is strange...
a good start.. now I'll start with the active/active installation of sql
server 2000 EE cluster and let you know if I face any issue...
P.S.: I'm installing it on W2K3EE SP1 cluster...
Thanks,
best regards,
Samo
"Samo" wrote:
[vbcol=seagreen]
> I've used the Cluster service account which has local admin rights, log on as
> service, etc on both nodes but the same application eventid 4383 error
> persist and msdtc failed to start ...
> --
> best regards,
> Samo
>
> "Geoff N. Hiten" wrote:
|||Hi,
I'm interested by what you say about using the cluster service account.
Did you use this account to start the DTC service?
Steve
"Samo" wrote:
[vbcol=seagreen]
> Just to let you know , the MSDTC resource started without problem after
> using the cluster service account and "restarting the cluster service" which
> is strange...
> a good start.. now I'll start with the active/active installation of sql
> server 2000 EE cluster and let you know if I face any issue...
> P.S.: I'm installing it on W2K3EE SP1 cluster...
> Thanks,
> --
> best regards,
> Samo
>
> "Samo" wrote: