OLE DB provider SQLNCLI for linked server returned message Cannot start more transactions on this session

OLE DB provider SQLNCLI for linked server returned message Cannot start more transactions on this session

 OLE DB provider "SQLNCLI" for linked server  returned message "Cannot start more transactions on this session."


Quick Fix: 
add below statement into your stored procedure who updates or transfer data on multiple server in transaction mode


SET XACT_ABORT ON

Here XACT_ABORT mode needs to be turned on

Tags:

OLE DB provider SQLNCLI for linked server returned message The partner transaction manager has disabled its support for remotenetwork transactionsSql Server MirroringASp.net 2.0 step by step Membership Provider The-MicrosoftJetOLEDB40-provider-is-not-registered-on-the-local-machineMS SQL server shutdownSessions In AspnetMembership ProviderWeb Hosting ProvidersIRequiresSessionState and sessionaspnet development server failed to start listening on portAsp.net Interview Questions for 2 years or 3 years experiance

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.