Overview


This Article is related to the common issue faced by many of DBA’s while using the Link server. Generally, we face this issue while performing DML operations or executing the stored procedure remotely via link server if the MSDTC configuration is not correct.

Problem Statement


"The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server "xx-xx-xxx" was unable to begin a distributed transaction"

After connecting to the Replication monitor, it had one of the most common errors.

Solution



1. Click Start, click Run, type “dcomcnfg” and then click OK to open Component Services.
2. In the console tree, Expand Component Services, Expand Computers, click to expand My Computer, click to expand Distributed Transaction Coordinator, and then click Local DTC.
3. Right click Local DTC and click Properties to display the Local DTC Properties dialog box.
4. Click the Security tab.
5. Set the following options on the Security tab of the Local DTC Properties dialog box and click OK.



These steps will help resolve the issue completely.