top of page
Search

SQL Server Configure Distributed Transaction Coordinator (DTC)

  • Writer: Kunal Ranpura
    Kunal Ranpura
  • Dec 13, 2019
  • 1 min read

Error: If DTC is not configured

1 12-09-2019 15:01:13: Failed - "The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server "ServerName" was unable to begin a distributed transaction.

OLE DB provider "SQLNCLI11" for linked server "ServerName" returned message

Steps to configure DTC:


1). open cmd as admin and type the following: dcomcnfg

2). Go to Local DTC properties and security tab. Configure Security settings as below.


ree

3). Make Sure windows firewall is allowing all traffic and ports for DTC.

Comments

bottom of page