linked server SOURCESERVER was unable to begin a distributed transaction. - by Dinesh Asanka

Status : 

  Not Reproducible<br /><br />
		The product team could not reproduce this item with the description and steps provided.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


2
0
Sign in
to vote
ID 243725 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 12/6/2006 2:52:40 AM
Access Restriction Public

Description

I have requriment of update data in a linkedserver SQL Server from a Trigger.
How Ever, I am getting follwing error when I tried it.
Update can be done from simple query and it is failing only in Trigger.

OLE DB provider "SQLNCLI" for linked server SOURCESERVER returned message "No transaction is active.".
Msg 7391, Level 16, State 2, Procedure TR_U_DimClient_sanj, Line 32
The operation could not be performed because OLE DB provider "SQLNCLI" for linked server SOURCESERVER was unable to begin a distributed transaction.

I have set XACT_ABORT ON and REOMTE PROCEDURE ON also MSDTC is also running. HOSTS file is also updated.
both servers named servers. Is that can be the problem
Sign in to post a comment.
Posted by Microsoft on 12/7/2006 at 11:57 AM
Error 7391 can happen most likely when network DTC access is disabled on Windows, which is default on Windows 2003 for security reason.

You can enable this by:
Control Panel --> Add or Remove Programs" --> Add/Remove Windows Components --> Application Server --> Detail --> "Enable network DTC access".

You can also verify:
Administrative Tools -> Component Services -> expand Component Services -> Expand Computer -> Right click My Computer -> Select Properties -> MSDTC tab -> Security Configuration -> Enable Network DTC Access -> Check all sub-boxes -> Ensure logon account is NT AUTHORITY\NetworkService -> Click OKs.
Posted by Dinesh Asanka on 12/7/2006 at 1:53 AM
Status has changed. Why??
any comments