OLE DB provider "SQLNCLI10" for linked server "x.x.x.x" returned message "No transaction is active.".

 

OLE DB provider "SQLNCLI10" for linked server "x.x.x.x" returned message "No transaction is active.".

OLE DB provider "SQLNCLI11" for linked server "x.x.x.x" returned message "The transaction manager has disabled its support for remote/network transactions.".

 解决办法，是链接时，使用IP，改为服务器名即可。