Msg 7391, Level 16, State 2, Line 23 – Error while running Linked Server
Posted by Jugal Shah on November 10, 2009
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.
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
