MSDTC not available

Question

Post reply

MSDTC not available

dips1231

SSC-Addicted

Points: 401
More actions
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

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

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

Rodrigo Acosta SSC-Insane Points: 21261 More actions · Answer 1

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

dips1231 SSC-Addicted Points: 401 More actions · Answer 2

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.

Antares686 SSC Guru Points: 125444 More actions · Answer 3

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.

dips1231 SSC-Addicted Points: 401 More actions · Answer 4

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

zach_john SSCertifiable Points: 5922 More actions · Answer 5

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

Simon Sabin SSCrazy Eights Points: 8142 More actions · Answer 6

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

Antares686 SSC Guru Points: 125444 More actions · Answer 7

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

dbuchan SSCrazy Points: 2328 More actions · Answer 8

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>

zach_john SSCertifiable Points: 5922 More actions · Answer 9

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

zach_john SSCertifiable Points: 5922 More actions · Answer 10

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