Post reply

MSDTC not available

  • October 31, 2002 at 3:31 pm

    #58407

    I have 3 instances of SQL Server running on the server machine. Out of the 3 instances MSDTC is working on 2 instances but is failing at one of the instances. Don't know what is the reason behind it.

    Alos, one very strange thing I noticed - msdtc is not running as a service in my task manager.

    I don't know what the problem is ?

    Can you guys provide some insight..

    Thanks Much...

    dips1231

  • October 31, 2002 at 3:45 pm

    #439999

    Any difference within the 3 instances? Wich one did you installed last?

  • October 31, 2002 at 3:54 pm

    #440002

    The 3 instances are -

    Dev, Int, Tst..and I installed the Tst one the last. And the code is working on Dev and Tst and not on Int. Why?

    And msdtc is running as a service I kinda overlooked it.

  • November 1, 2002 at 8:13 am

    #440050

    What is the error when failing and have you check the EventViewer in Windows to check for messages from the Service. Always start with looking there.

  • November 1, 2002 at 9:35 am

    #440057

    Hey Guys,

    This is the error message I'm getting in the EVENT VIEWER:

    String message: Session idle timeout over, tearing down the session.

    Thanks,

    -dips1231

  • November 1, 2002 at 9:45 am

    #440060

    Session idle timeout over, tearing down the session.

    I see this in my event viewer regulary, several times a day. Is this not normal when dtc is not in use? If not, what should I be looking at to correct this?

    Zach

    John Zacharkan


    John Zacharkan

  • November 2, 2002 at 6:25 am

    #440130

    I get it as well and doesn't seem to cause a problem

    Simon Sabin

    Co-author of SQL Server 2000 XML Distilled

    http://www.amazon.co.uk/exec/obidos/ASIN/1904347088


    Simon Sabin
    SQL Server MVP

    http://sqlblogcasts.com/blogs/simons

  • November 2, 2002 at 9:36 am

    #440142

    DOn't believe that is it, that should be an informational message, look for warning or error type message.

  • November 3, 2002 at 4:48 pm

    #440165

    There is a logfile for DTC. Check out 'DTC Log' under System32.

    Also check out DAC.EXE in the System32 folder.(DTC Admin Console)

    Possibly a DTCTRACE.exe session will help.

    DB


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • November 4, 2002 at 10:09 am

    #440230

    Thanks Antares686,

    But I want to make sure that 'Session idle timeout over, tearing down the session.' informational message is occuring by design and NOT occuring needlessly.

    The message is not in BOL. Where could I find the DTC documentation?

    quote:

    There is a logfile for DTC. Check out 'DTC Log' under System32.

    Also check out DAC.EXE in the System32 folder.(DTC Admin Console)

    Possibly a DTCTRACE.exe session will help.

    DB

    John Zacharkan


    John Zacharkan

  • November 4, 2002 at 10:10 am

    #440231

    Thanks Antares686,

    But I want to make sure that 'Session idle timeout over, tearing down the session.' informational message is occuring by design and NOT occuring needlessly.

    The message is not in BOL. Where could I find the DTC documentation?

    sorry about that - I quoted the the wrong poster.

    quote:

    DOn't believe that is it, that should be an informational message, look for warning or error type message.

    John Zacharkan


    John Zacharkan

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply