SQL 2005 Linked Server

jdr0606
jdr0606 used Ask the Experts™
on
I can query a table via linked server however if I try to update a table via a linked server pathing I get the following error.
 
OLE DB provider "SQLNCLI" for linked server "m24prd" returned message "The transaction manager has disabled its support for remote/network transactions.".
Msg 7391, Level 16, State 2, Line 1
The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "m24prd" was unable to begin a distributed transaction.
 
Suggestions?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Billing Engineer
Most Valuable Expert 2014
Top Expert 2009
Commented:
I have found 1 workaround: copy (insert) the data into a local staging table ...

apart from that, you would need to ensure that the DTC service is running and properly configured on the remote server AND the local server.
musalmanERP Consultant

Commented:
Try :

      SET XACT_ABORT ON

      Before BEGIN TRAN

Author

Commented:
Currently working with a local engineer to correct and will update when the issue is resolved.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial