What is MSDTC and does AGRIS support it?

Problem

Does AGRIS require MSDTC?

Solution

Yes AGRIS does use and does require MSDTC.

MSDTC is a Windows service providing transaction infrastructure for distributed systems.

In this case, a transaction means a general way of structuring the interactions between autonomous agents in a distributed system. 

Does AGRIS support it?  Yes.

The major areas of AGRIS that need MSDTC include AGRIS Web Services as well as Agroguide. This service is needed in order to manage and maintain our server components even if those components do not require transactions. 

• Page:
  MSSQL Server and Client Configuration Recommendations and Requirements
• Page:
  How to remove MSSQL records associated with a failed dataset migration or dataset copy - Generate Delete Data from All Tables by TenantID
• Page:
  MSSQL How To find the active connections to the database. (system or users)
• Page:
  MSSQL Transaction Timeout and Rollback
• Page:
  MSSQL Maximum server memory setting - How do I determine if MSSQL is using too much memory or storage space?