"Samo" wrote:

> 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:
>
> > 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...
> > > > 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\mtxclusetuphelper.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
> > >
> > >