May 25, 2007 at 8:23 am
Hi,
I am running following script on server A. Server B is configured as linked server to A.
SET xact_abort ON
GO
begin tran
INSERT INTO B.table1.dbo.CUSTOMER (CUSTOMER_ID,PLAN_CODE)
VALUES (1001,100)
rollback tran
The above script when run run on server A gives following error:-
Error..
Server: Msg 7391, Level 16, State 1, Line 3
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].
Pls. advise why this error occurs. How to insert records in linked server.
May 25, 2007 at 8:37 am
"The problem occurs because Microsoft Distributed Transaction Coordinator (MS DTC) is not configured for network access. By default, the network access settings of MS DTC are disabled on new installations of SQL Server 2000 on computers that are running Windows Server 2003"
See if the Knowledge Base article associated with the above statement helps any:
http://support.microsoft.com/kb/329332
James.
May 25, 2007 at 8:41 am
I forgot to mention:
I did all these settings on Server A, Restart DTC,SQL Agent and reboot the system as well.
One more thing server A in win 2003 & server b (linked) is Win 200.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply