[42000] SQL call failed. linked sql server no transaction is active

hi all, when i run the same store procedure from SQL (the store procedure does an update statement on other linked server) the procedure works but when running it through Scribe insight from the workbench i got this error 

[42000] SQL call failed. The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server "XXXXXX" was unable to begin a distributed transaction. OLE DB provider "SQLNCLI11" for linked server "XXXXX" returned message "No transaction is active.".  any idea on how to fix... i did found some articles on configuring the DTC service but no luck with it... it does work with SQL so it should work with Scribe using the SQL Connection....please any insight on scribe insight :)

(2) Answers

Login