Venio Console: How to enable DTC?

Problem

How do I enable DTC? 

Resolution

Navigate to Server Manager>>Component Services>>Computers>>My Computer>>Distributed Transaction Coordinator>>Local DTC

Right click on the properties>>Security

On security settings make sure the following are checked:

• Network DTC Access
• Allow Remote Clients
• Allow Remote Administration
• Allow Inbound
• Allow Outbound
• Enable XA Transactions
• Enable SNA LU 6.2 transactions

What issues occurs when DTC is not enabled?

When SQL server and IIS are not on different servers and also when Project Databases and VenioPCD are on different servers, issues such as review layout not saved or not enabled might occur. 

Therefore enabling DTC will resolve this issue. Also we need to add FIREWALL Rules to Allow the Traffic In and Out. The following steps will create Inbound rule. 

1. Open Windows Firewall (run as administrator) and select Advanced Settings on the left.

   Or, In Server Manager, select Tools, and then select Windows Firewall with Advanced Security.

2. Right click Inbound Rules, and select New Rule.

3. In the wizard:

   1. Select Program, and select Next.
   2. Set the program path to %SystemRoot%\system32\msdtc.exe, and select Next.
   3. Allow the connection, and select Next.
   4. Make sure Domain is selected, and select Next.
   5. Enter any name, such as MSDTC, and select Finish.

4. Complete the wizard, and close Windows Firewall.

Same steps for creating OutBound Rules

1. Right click Outbound Rules, and select New Rule.

2. In the wizard:

   1. Select Program, and select Next.
   2. Set the program path to %SystemRoot%\system32\msdtc.exe, and select Next.
   3. Allow the connection, and select Next.
   4. Make sure Domain is selected, and select Next.
   5. Enter any name, such as MSDTC, and select Finish.

3. Complete the wizard, and close Windows Firewall.