-
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.
-
Which sql2k edition do you use? MSDE2k? Applied sql2k sp3a?
-
Yes, 2k Developer Edition w/ Service Pack 3a applied.
-
Is msdtc running on the box?
-
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).
-
Did you check kb article 839279?
-
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
-
Forum Rules
|
|