Friday, July 29, 2011

SQL Server Error: The partner transaction manager has disabled its support for remote/network transactions

I was getting foll. error when remotely executing a stored procedure over SQL Server Linked Server.


OLE DB provider "SQLNCLI10" for linked server "LINKEDSERVERNAME" returned message "The partner transaction manager has disabled its support for remote/network transactions.".
Msg 7391, Level 16, State 2
The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "LINKEDSERVERNAME" was unable to begin a distributed transaction.

After much research I found the solutions using these links:
http://www.sqlwebpedia.com/content/msdtc-troubleshooting

http://social.msdn.microsoft.com/forums/en-US/adodotnetdataproviders/thread/7172223f-acbe-4472-8cdf-feec80fd2e64/

Much thanks to Chuck Lathrope and Eric for these!

No comments: