Post reply

MSDTC Failed to start

  • January 6, 2006 at 3:53 am

    #166675

    Hi All,

    When trying to execute a SSIS package with transactions required, I get the following error.

    Error: The SSIS Runtime has failed to start the distributed transaction due to error 0x8004D027 "MSDTC was unable to read its configuration information.". The DTC transaction failed to start. This could occur because the MSDTC Service is not running.

    The MSTD service is already running. I can create a distributed transaction from withing SQL but not when SSIS is trying to do it.

     

    Anyone ideas?

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

  • January 9, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • March 15, 2006 at 5:43 pm

    #626930

    Hi

     

    I had this problem and resolved it be stopping and re-starting MSDTC.

    Go figure!

     

    Jays

  • March 16, 2006 at 7:09 am

    #627001

    I did a net stop / start on MS DTC and that worked for me.

  • March 24, 2006 at 8:52 am

    #628652

    check this :

     http://tsutha.blogspot.com/2005/12/msdtc-what-pain.html

     

    solution:

     

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q306843

     

  • February 17, 2009 at 3:04 pm

    #945543

    I tried all of the above solution recommendations but I still get thesame error. The only thing that may be different is that I am running in a 64bit machine. I ran my SSIS package in a 32bit and it runs successfully. Anybody have trouble with running in 64bit?

    Thanks in advance.

Viewing 6 posts - 1 through 5 (of 5 total)

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