MSSQL Linked Server

Hello,
we had 2 databases 'abc' and 'xyz' on server 'A'. we used to execute trigger on 'xyz' server(if insert data to a table) and inside trigger we used to execute proc  'proc1' on 'abc' server . 'proc1' used to call another proc in 'abc' database which inserts some data on 'abc' database

Now 'abc' and 'xyz' are moved to 2 different servers . Inside trigger on 'xyz' server I am executing proc with linked server . But now I am receiving "linked server unable to begin distributed transactions. Oledb provider for linked server returned message the transaction manager has disabled its support for remote\network transactions"
vijay11Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Brian ChanConnect With a Mentor DBACommented:
Someone has gone through this before, this sounds like your problem:

The transaction manager has disabled its support for remote/network transactions

Linked Server relies on MS DTC, so make sure the service is set up properly and enable for the linked server to work on both SQL servers
0
 
vijay11Author Commented:
Thanks for the reply. Please let me know if is possible to rewrite the query with out enabling this.
0
 
Brian ChanConnect With a Mentor DBACommented:
@vijay11

Well, since your transaction spans across different SQL servers, MS DTC services is required to coordinate the remote transaction. In other words, change the code would not help to workaround.
0
 
vijay11Author Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.