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.
3). Make Sure windows firewall is allowing all traffic and ports for DTC.
Comments