Results 1 to 7 of 7

Thread: Distributed Transactions in SQL 2000

  1. #1
    Join Date
    Nov 2004
    Posts
    3

    Distributed Transactions in SQL 2000

    We just upgraded from SQL 7 to 2000 and for some reason I am unable to perform distributed transactions. I keep getting the following error:

    OLE DB error trace [OLE/DB Provider 'MSDASQL' ITransaction Join:: JoinTransaction returned 0x8004d00a]. Operation could not be performed because the OLE DB provider 'MSDASQL' was unable to begin a distributed transaction

    I tried a few of the fixes recommended on the microsoft website but they did not solve the problem. We are still using the same O/S (Windows 2000 Pro), so the only thing that has changed is the server.

    Any help would be appreciated.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Which sql2k edition do you use? MSDE2k? Applied sql2k sp3a?

  3. #3
    Join Date
    Nov 2004
    Posts
    3
    Yes, 2k Developer Edition w/ Service Pack 3a applied.

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    Is msdtc running on the box?

  5. #5
    Join Date
    Nov 2004
    Posts
    3
    Yes, msdtc is running. I have the servers linked w/ appropriate IDs and PWs. I am able to view the tables on the linked servers in Enterprise Manager. However, I cannot query the servers from a stored procedure (I get the error in my original post).

  6. #6
    Join Date
    Sep 2002
    Posts
    5,938
    Did you check kb article 839279?

  7. #7
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Is the server you are linking to outside a firewall?

    Can you do this

    begin tran
    insert into linkedtable

    commit
    Last edited by skhanal; 11-11-2004 at 01:42 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •