OLE DB provider SQLNCLI for linked server returned message The partner transaction manager has disabled its support for remotenetwork transactions

OLE DB provider SQLNCLI for linked server returned message The partner transaction manager has disabled its support for remotenetwork transactions

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

QUICK FIX:  Disable Fire wall, Anti virus which blocks PORTS used by Distributed transaction cordinator.


Or add those ports into firewall exceptions.

Satalaj.

Tags:

OLE DB provider SQLNCLI for linked server returned message Cannot start more transactions on this sessionSql Server MirroringASp.net 2.0 step by step Membership Provider Error The SSIS Runtime has failed to start the distributed transaction due to error 0x8004D01B The Transaction Manager is not available The DTC transaction failed to start This could occur because the MSDTC Service is not runningThe-MicrosoftJetOLEDB40-provider-is-not-registered-on-the-local-machineMembership ProviderMS SQL server shutdownMS SQL server Transaction commit rollbackConnection PoolingWeb Hosting Providerstransaction

Author

My name is Satalaj, but people call me Sat. Here is my homepage: . I live in Pune, PN and work as a Software Engineer. I'm former MVP in ASP.net year 2010.
Disclaimer: Views or opinion expressed here are my personal research and it has nothing to do with my employer. You are free to use the code, ideas/hints in your projects. However, you should not copy and paste my original content to other web sites. Feel free to copy or extend the code.
If you want to fight with me, this website is not for you.
 

I'm Satalaj.