OLE DB Provider "SQLNCLI11" for linked server "DbLink01" is unable to begin a distributed TRANSAC
The following solutions are collected from the Internet, but for distributed transactions that are not in the same network segment, they cannot be solved:
I'm here to report the error details are:
Exception information: The operation could is performed because OLE DB provider "SQLNCLI11" for linked server "DbLink01" is unable to B Egin a distributed transaction.
OLE DB provider ' SQLNCLI11 ' for linked server ' DBLINK01 ' returned message ' does not have an active transaction. ".
Name of the application or object that caused the error:. Net SqlClient Data Provider
Method that throws the current exception:
Exception-related help:
Stack information:
In System.Data.SqlClient.SqlConnection.OnError (SqlException exception, Boolean breakconnection, Action ' 1 Wrapcloseinaction)
In System.Data.SqlClient.SqlInternalConnection.OnError (SqlException exception, Boolean breakconnection, Action ' 1 Wrapcloseinaction)
In System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning (Tdsparserstateobject stateobj, Boolean Callerhasconnectionlock, Boolean Asyncclose)
In System.Data.SqlClient.TdsParser.TryRun (Runbehavior runbehavior, SqlCommand Cmdhandler, SqlDataReader DataStream, Bulkcopysimpleresultset Bulkcopyhandler, Tdsparserstateobject stateobj, boolean& dataReady)
In System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds (String methodname, Boolean async, Int32 timeout)
In System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery (TaskCompletionSource ' 1 completion, String methodname, Boolean sendtopipe, Int32 timeout, Boolean asyncwrite)
In System.Data.SqlClient.SqlCommand.ExecuteNonQuery ()
1, check the local machine and the target machine MSDTC (distributed Transaction Coordinator) service has been enabled, the specific location as shown below:
2. MSDTC Setup
Open the Administrative Tools-Component Services to open the Component Services-computer-My Computer---Distributed transaction coordinator– on the right Key property Security tab on the Local DTC set: Select Network DTC Access. In client management, select "Allow remote Client" "Allow remote Management", in transaction management communication, select "Allow Inbound" "Allow Outbound" "Do not require authentication" to ensure that the DTC login account is: NT AUTHORITY\NetworkService.