Results 1 to 5 of 5

Thread: MS DTC service failing to start (Distributed Transaction Service)

  1. #1
    Robabob Guest

    MS DTC service failing to start (Distributed Transaction Service)

    I've setup a working 2 node cluster which currently has no applications
    configured but I will be adding SQL shortly. The problem I have is that each
    time the server starts I get a service failed to start message. In the event
    log the specific service is the MSDTC service (Distributed Transaction
    Service). The message given is:

    The MS DTC service was started before the cluster service on this cluster
    node. This service will now be stopped. If MSDTC has been configured to run
    on a cluster, the MS DTC resource will be brought online by the cluster
    service when it starts. Error Specifics:
    d:\nt\com\complus\dtc\shared\mtxclu\mtxclusetuphelper.cpp:932, Pid: 3844,
    CmdLine: "C:\WINDOWS\cluster\resrcmon.exe" -e 1244 -m 1256 -p 2164

    Firstly I'm not sure if I need MS DTC for anything? Assuming I do if I set
    the service to manual will cluster service start it automatically?

  2. #2
    Chuck Timon [Microsoft] Guest

    Re: MS DTC service failing to start (Distributed Transaction Service)

    If you do not need MSDTC then you can disable it (Set to Manual if you have
    not yet applied SP1 for W2K3 or it will fail)...but since you are clustering
    SQL, there is a good chance you will need it...check with the DBA.

    If you need it, follow the procedures in -
    http://support.microsoft.com/default...5bLN%5d;301600

    If this is multi-instance SQL you will need to apply the following as a
    minimum to fix a problem with SQL and MSDTC

    http://support.microsoft.com/kb/912818/en-us.

    Also, please review - http://support.microsoft.com/kb/899191

    --
    Chuck Timon, Jr.
    Microsoft Corporation
    Longhorn Readiness Team
    This posting is provided "AS IS" with no
    warranties, and confers no rights.



    "Robabob" <r(dot)jeffrey(att)ids(dot)ac(dot)uk> wrote in message
    news:A89EEF3E-10BC-403D-8DC8-A1FA5C1CC834@microsoft.com...
    > I've setup a working 2 node cluster which currently has no applications
    > configured but I will be adding SQL shortly. The problem I have is that
    > each
    > time the server starts I get a service failed to start message. In the
    > event
    > log the specific service is the MSDTC service (Distributed Transaction
    > Service). The message given is:
    >
    > The MS DTC service was started before the cluster service on this cluster
    > node. This service will now be stopped. If MSDTC has been configured to
    > run
    > on a cluster, the MS DTC resource will be brought online by the cluster
    > service when it starts. Error Specifics:
    > d:\nt\com\complus\dtc\shared\mtxclu\mtxclusetuphelper.cpp:932, Pid: 3844,
    > CmdLine: "C:\WINDOWS\cluster\resrcmon.exe" -e 1244 -m 1256 -p 2164
    >
    > Firstly I'm not sure if I need MS DTC for anything? Assuming I do if I
    > set
    > the service to manual will cluster service start it automatically?




  3. #3
    Robabob Guest

    Re: MS DTC service failing to start (Distributed Transaction Servi

    Hello Chuck,

    Thanks for this, I managed to find some of this info out but this has put me
    on the right track. On eproblem I have now is that I need to rebuild the
    shared disk array to create a disk for MSDTC. The thing I can't find
    anywhere is what size to allocate. I currently have: Quorum 500MB and
    Datastore(SQL) 200GB; is it a similar thing to the Quorom, i.e. would 500MB
    do?

    Thanks again for the help!

    Rob :o)

    "Chuck Timon [Microsoft]" wrote:

    > If you do not need MSDTC then you can disable it (Set to Manual if you have
    > not yet applied SP1 for W2K3 or it will fail)...but since you are clustering
    > SQL, there is a good chance you will need it...check with the DBA.
    >
    > If you need it, follow the procedures in -
    > http://support.microsoft.com/default...5bLN%5d;301600
    >
    > If this is multi-instance SQL you will need to apply the following as a
    > minimum to fix a problem with SQL and MSDTC
    >
    > http://support.microsoft.com/kb/912818/en-us.
    >
    > Also, please review - http://support.microsoft.com/kb/899191
    >
    > --
    > Chuck Timon, Jr.
    > Microsoft Corporation
    > Longhorn Readiness Team
    > This posting is provided "AS IS" with no
    > warranties, and confers no rights.
    >
    >
    >
    > "Robabob" <r(dot)jeffrey(att)ids(dot)ac(dot)uk> wrote in message
    > news:A89EEF3E-10BC-403D-8DC8-A1FA5C1CC834@microsoft.com...
    > > I've setup a working 2 node cluster which currently has no applications
    > > configured but I will be adding SQL shortly. The problem I have is that
    > > each
    > > time the server starts I get a service failed to start message. In the
    > > event
    > > log the specific service is the MSDTC service (Distributed Transaction
    > > Service). The message given is:
    > >
    > > The MS DTC service was started before the cluster service on this cluster
    > > node. This service will now be stopped. If MSDTC has been configured to
    > > run
    > > on a cluster, the MS DTC resource will be brought online by the cluster
    > > service when it starts. Error Specifics:
    > > d:\nt\com\complus\dtc\shared\mtxclu\mtxclusetuphelper.cpp:932, Pid: 3844,
    > > CmdLine: "C:\WINDOWS\cluster\resrcmon.exe" -e 1244 -m 1256 -p 2164
    > >
    > > Firstly I'm not sure if I need MS DTC for anything? Assuming I do if I
    > > set
    > > the service to manual will cluster service start it automatically?

    >
    >
    >


  4. #4
    Chuck Timon [Microsoft] Guest

    Re: MS DTC service failing to start (Distributed Transaction Servi

    You can actually place the MSDTC resource in the cluster group and use the
    resources there, including the quorum drive to store the data. It's a
    discussion that has been going on since the days of NT 4.0 clustering -
    "How to deal with the MSDTC cluster resource?" Well, as far as the
    Microsoft cluster support team is concerned, you can use the resources in
    the quorum group. In fact, Exchange even makes this statement in their
    documentation now.

    SQL should be fine as long as the COM+ rollup fix is installed.

    For Longhorn clustering, we will be allowing the creation of a multiple
    MSDTC resources in a cluster...so be looking for that.

    --
    Chuck Timon, Jr.
    Microsoft Corporation
    Longhorn Readiness Team
    This posting is provided "AS IS" with no
    warranties, and confers no rights.




    "Robabob" <r(dot)jeffrey(att)ids(dot)ac(dot)uk> wrote in message
    news:0B678506-BE12-4690-AB57-6D2A8D8A1F4B@microsoft.com...
    > Hello Chuck,
    >
    > Thanks for this, I managed to find some of this info out but this has put
    > me
    > on the right track. On eproblem I have now is that I need to rebuild the
    > shared disk array to create a disk for MSDTC. The thing I can't find
    > anywhere is what size to allocate. I currently have: Quorum 500MB and
    > Datastore(SQL) 200GB; is it a similar thing to the Quorom, i.e. would
    > 500MB
    > do?
    >
    > Thanks again for the help!
    >
    > Rob :o)
    >
    > "Chuck Timon [Microsoft]" wrote:
    >
    >> If you do not need MSDTC then you can disable it (Set to Manual if you
    >> have
    >> not yet applied SP1 for W2K3 or it will fail)...but since you are
    >> clustering
    >> SQL, there is a good chance you will need it...check with the DBA.
    >>
    >> If you need it, follow the procedures in -
    >> http://support.microsoft.com/default...5bLN%5d;301600
    >>
    >> If this is multi-instance SQL you will need to apply the following as a
    >> minimum to fix a problem with SQL and MSDTC
    >>
    >> http://support.microsoft.com/kb/912818/en-us.
    >>
    >> Also, please review - http://support.microsoft.com/kb/899191
    >>
    >> --
    >> Chuck Timon, Jr.
    >> Microsoft Corporation
    >> Longhorn Readiness Team
    >> This posting is provided "AS IS" with no
    >> warranties, and confers no rights.
    >>
    >>
    >>
    >> "Robabob" <r(dot)jeffrey(att)ids(dot)ac(dot)uk> wrote in message
    >> news:A89EEF3E-10BC-403D-8DC8-A1FA5C1CC834@microsoft.com...
    >> > I've setup a working 2 node cluster which currently has no applications
    >> > configured but I will be adding SQL shortly. The problem I have is
    >> > that
    >> > each
    >> > time the server starts I get a service failed to start message. In the
    >> > event
    >> > log the specific service is the MSDTC service (Distributed Transaction
    >> > Service). The message given is:
    >> >
    >> > The MS DTC service was started before the cluster service on this
    >> > cluster
    >> > node. This service will now be stopped. If MSDTC has been configured to
    >> > run
    >> > on a cluster, the MS DTC resource will be brought online by the cluster
    >> > service when it starts. Error Specifics:
    >> > d:\nt\com\complus\dtc\shared\mtxclu\mtxclusetuphelper.cpp:932, Pid:
    >> > 3844,
    >> > CmdLine: "C:\WINDOWS\cluster\resrcmon.exe" -e 1244 -m 1256 -p 2164
    >> >
    >> > Firstly I'm not sure if I need MS DTC for anything? Assuming I do if I
    >> > set
    >> > the service to manual will cluster service start it automatically?

    >>
    >>
    >>




  5. #5
    Russ Kaufmann \(MVP\) Guest

    Re: MS DTC service failing to start (Distributed Transaction Servi

    "Chuck Timon [Microsoft]" <ctimon@online.microsoft.com> wrote in message
    news:ulYqjMhvGHA.5088@TK2MSFTNGP06.phx.gbl...
    > You can actually place the MSDTC resource in the cluster group and use the
    > resources there, including the quorum drive to store the data. It's a
    > discussion that has been going on since the days of NT 4.0 clustering -
    > "How to deal with the MSDTC cluster resource?" Well, as far as the
    > Microsoft cluster support team is concerned, you can use the resources in
    > the quorum group. In fact, Exchange even makes this statement in their
    > documentation now.
    >
    > SQL should be fine as long as the COM+ rollup fix is installed.


    There should be no problems unless your applications are using two phase
    commits when working with SQL server. In which case, if using two phase
    commits, you may want to move MSDTC to its own resources for performance
    reasons.



    --
    Russ Kaufmann
    MVP - Windows Server - Clustering
    ClusterHelp.com, a Microsoft Certified Gold Partner
    Web http://www.clusterhelp.com
    Blog http://msmvps.com/clusterhelp




Similar Threads

  1. Replies: 3
    Last Post: 27-01-2010, 07:48 PM
  2. Replies: 1
    Last Post: 17-07-2009, 07:09 PM
  3. Cannot start SPAdmin service
    By ABBOTT in forum Operating Systems
    Replies: 3
    Last Post: 26-06-2009, 09:08 PM
  4. Can't start Event Log Service
    By Andrew in forum Vista Help
    Replies: 5
    Last Post: 28-03-2007, 07:25 AM
  5. Replies: 5
    Last Post: 18-11-2005, 08:00 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,660,172.31320 seconds with 17 queries