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


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

 

Advertisements

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

  1. rahul 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

Thanks for the comment, will get back to you soon... Jugal Shah

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s