Failed to execute collection [DBSS_DTC_Information], reason=Cannot add record to Record container (4310109)

Whenever the DBSS_DTC_Information collection runs it gets the following error (there can similar errors to the below but the solution is applicable for all):

The following message appears in the SQL Server agent log:

---

---

The following alarm is raised even though the DTC is running on a machine separated from the SQL Server itself:

---
The Distributed Transaction Coordinator (DTC) service is installed but not running.
---

• How to configure the Agent to address DTC service located on a machine separated from the SQL Server itself?
• How to configure the Agent to address DTC service located on the same machine where the SQL Server is?
• What does this alarm mean and what should we do to resolve this issue?

The error is being receive due to unexpected configuration of the customer environment (f.g : number of DTC services which running on the same host machine).

There are two main scenarios when using DTC:

1. the DTC resides on the same SQL Server host
2. the DTC resides on its own machine and serves the SQL Servers

There are two main scenarios when using DTC:

1. the DTC resides on the same SQL Server host
2. the DTC resides on its own machine and serves the SQL Servers

The SQL Server agentprovides with the option to address each of the scenarios above.

SCENARIO 1 - the DTC resides on the same SQL Server host

The Agent Status Property parameter "DTC service name" should be set with the name of the DTC service that services the SQL-Server instance. The names of the DTC services should be taken from the following WMI query (can be run via WMI explorer):

select Name from Win32_PerfFormattedData_MSDTC_DistributedTransactionCoordinator

1. Navigate to Administration | Agents | Agent Status
2. Select the database agent
3. Click Edit Properties
4. Click the link to Modify the Private Properties of the SQL Server agent
5. Update the DTC Service Name field in DTC Information Collection Parameters with the result from the query listed above
6. Save the changes and then deactivate/activate the SQL Server agent

* In this scenario there is no need to fill in the DTC SERVICE HOST
* In this scenario there is no need to fill in the OS login credentials.

Scenario 2 - Setting the Agent to address DTC service which is installed on its own machine

In this case, fill in the:

1. Navigate to Administration | Agents | Agent Status
2. Select the database agent
3. Click Edit Properties
4. Click the link to Modify the Private Properties of the SQL Server agent
5. Update the DTC Service Host field in DTC Information Collection Parameters with DTC virtual machine name
6. Type in the OS login to the DTC machine - use the same Foglight OS user credentials that are used for the Agent
7. Save the changes and then deactivate/activate the SQL Server agent
8. If the DTC machine contains several DTC services rather than a single one, type in the DTC SERVICE HOST as well as DTC service name and OS login credentials. Please refer to the setting the Agent to address DTC service which is installed on the same SQL Server host as above.