Msg 7391, Level 16, State 2, Line 23 – Error while running Linked Server

1 Reply

Error Description 

OLE DB provider “SQLNCLI” for linked server “MYView” returned message “The transaction manager has disabled its support for remote/network transactions.”.

 Msg 7391, Level 16, State 2, Line 23

 The operation could not be performed because OLE DB provider “SQLNCLI” for linked server “MYView” was unable to begin a distributed transaction.

 Resolution:

1. Check whether DTC is blocked by firewall, if it is blocked by firewall release it.

2. Check or configure DTC to allow network connection as below.

 msdtc

Go to Control Panel ->Administrative Tools -> Component Services -> Expand the Computer Node -> Right click on My Computer) -> Click on Properties -> MS DTC Tab -> Security Configuration

 

1 thought on “Msg 7391, Level 16, State 2, Line 23 – Error while running Linked Server”

  1. rahul nasit's avatarrahul nasit

    hey , m rahul nasit , i face this kind of error while connecting

    i try almost all possible solution but it still cant be resolve

    colud u do any kind of help for solving this:

    “OLE DB provider “SQLNCLI10” for linked server “192.168.1.13” returned message “No transaction is active.”.
    Msg 7391, Level 16, State 2, Line 1
    The operation could not be performed because OLE DB provider “SQLNCLI10” for linked server “192.168.1.13” was unable to begin a distributed transaction.”

    Reply ↓

Leave a reply to rahul nasit Cancel reply