x

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, 2012 at 05:24 AM in Default

avatar image

innovator
335 15 15 20

(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, 2012 at 07:50 AM

avatar image

ThomasRushton ♦♦
40.3k 20 49 53

(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

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x133

asked: May 14, 2012 at 05:24 AM

Seen: 1791 times

Last Updated: May 14, 2012 at 09:03 AM

Copyright 2016 Redgate Software. Privacy Policy