We get below randomly from application. This same piece of code runs on another server.
: SQL statement failed —> System.Data.SqlClient.SqlException: Could not start a nested transaction for the OLE DB provider "SQLNCLI11" for the linked server "server". A nested transaction was required because the XACT_ABORT option was set to OFF.
We checked below the parameters
1. the firewall is off
The 2.DTC ping works well
3. No RPC port entry
4. Nothing is in the DTC logs (c: windows system32 msdtc trace)
We followed all the elements of this checklist
Has a person experienced random error code errors as above? What can be done to solve this problem? Only this error occurs when there is a huge load on the server because of disk issues (or we may be wrong)
All pointers on the use of tools / additional trace flags to intercept these random errors