March 28, 2004 at 11:49 pm
Hi guys,
I set up a transactional replication with updating subscription between server A and server B. Server A act as publisher, B as subscriber. When I tried to manipulate data on subscriber (hoping that the result would be sent to publisher), I got this following error message :
'New transaction cannot enlist in the specified transaction coordinator. Provider SQLOLEDB ITransactionJoin return 0x8004d00A. The operation could not be performed because OLEDB Provider 'SQLOLEDB' was unabled to begin a distributed transaction. '
What would be the cause of the problem ? Any ideas on how to work around it ?
I really appreciate your help ... Thanks in advance ...
March 29, 2004 at 5:34 am
When you update data at the subscriber, SQL begins a distributed transaction and apply that change in the subscriber and also in the publisher. If one of them fail, then both changes fail and are roll back.
First check if you can manually begin a distributed transaction. You can do something like this:
BEGIN DISTRIBUTED TRAN
SELECT TOP 10 * FROM ServerA.DBA.dbo.TableName
SELECT TOP 10 * FROM ServerB.DBB.dbo.TableName
COMMIT DISTRIBUTED TRAN
Tell us if anything goes wrong.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply