x
login about faq Site discussion (meta-askssc)

Problem updating table on linked server.

Hi,

Please help me with below scenario,

I am not getting any error while update a table that is on diferent server. but when I use Begin Tran I get below mentioned error.

"OLE DB provider "SQLNCLI" for linked server "192.168.10.115" returned message "The partner transaction manager has disabled its support for remote/network transactions.". Msg 7391, Level 16, State 2, Line 2 The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "192.168.11.103" was unable to begin a distributed transaction. "

My update statement is as

BEGIN TRAN
       update IB  
       set 
       IB.status = A.status
       from [192.168.11.103].Testdb.dbo.emp1 IB , emp2 A 
       where IB.eid = A.eid 
       and IB.form_no = A.form_no 

IF @@ERROR <> 0      
       BEGIN      
         ROLLBACK TRANSACTION      
         return -1      
       END
       ELSE
       BEGIN  
COMMIT TRANSACTION 
         END
more ▼

asked May 14 '12 at 05:24 AM in Default

innovator gravatar image

innovator
335 13 15 17

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Things to check:

  • DTC / Distributed Transaction Coordinator is running on both servers
  • Check that Network DTC access is allowed.

See here for more.

more ▼

answered May 14 '12 at 07:50 AM

ThomasRushton gravatar image

ThomasRushton ♦
29.4k 6 9 36

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x92

asked: May 14 '12 at 05:24 AM

Seen: 586 times

Last Updated: May 14 '12 at 09:03 AM

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.