February 20, 2004 at 2:15 am
select * from [remote_linked.server].db.dbo.table . This works fine but when I embed any statement into a proper distributed transaction it just hangs. I have all the correct syntax so I assume it's something to do with the msdtc's themselves. Any ideas what this might be. Thanks
February 20, 2004 at 2:25 am
here's the error message. The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].
February 20, 2004 at 9:23 am
Can you give a bit more specs about your configured environment?
K. Brian Kelley
@kbriankelley
February 21, 2004 at 9:09 pm
Is the MS Distributed Transaction Coordinator service running on the remote server?
February 23, 2004 at 9:49 am
both sql 2000 servers in same w2k domain using same domain service account for sql server service and sql agent service. Interestingly it doesn't make any difference if I use the domain service account or the local system for the MSDTC. Which should you use?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply