Announcement

Collapse
No announcement yet.

SQL Server DTS

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL Server DTS

    Hi,

    When running DTS in SQL Server 2000 I recieve that following error:

    Join Transaction returned 0x8004d00a

    Any ideas?

    Cheers

    P

  • #2
    it is:
    JoinTransaction returned 0x8004d00a i guess.

    already tried the following?

    http://www.google.nl/search?hl=nl&q=...00a+&meta=
    Marcel
    Technical Consultant
    Netherlands
    http://www.phetios.com
    http://blog.nessus.nl

    MCITP(EA, SA), MCSA/E 2003:Security, CCNA, SNAF, DCUCI, CCSA/E/E+ (R60), VCP4/5, NCDA, NCIE - SAN, NCIE - BR, EMCPE
    "No matter how secure, there is always the human factor."

    "Enjoy life today, tomorrow may never come."
    "If you're going through hell, keep going. ~Winston Churchill"

    Comment


    • #3
      Have a look at these.

      http://support.microsoft.com/kb/306212
      http://support.microsoft.com/kb/816701
      http://support.microsoft.com/kb/839279

      Dave, why the name Pedals ?

      topper
      * Shamelessly mentioning "Don't forget to add reputation!"

      Comment


      • #4
        Well it turns out that the problem is to do with Mutual Authentication,

        The source of the DTS is Windows 2000 and the destination is Windows 2003, at present only Windows 2003 & Windows XP SP2 support mutual authentication.

        Therefore to solve the problem I had to select No Authentication Required on the MSDTC.

        Thanks

        P

        Comment

        Working...
        X