• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 50
  • Last Modified:

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"
0
vijay11
Asked:
vijay11
  • 2
  • 2
2 Solutions
 
Brian ChanDBACommented:
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 ChanDBACommented:
@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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now