MSDTC on server 'Server Name' is unavailable

Question

Hi  On clicking the submit button MSDTC on server 'Server Name' is unavailable.

Renjith V S · Answer

RESOLUTION On the server where the trigger resides you need to turn the MSDTC service on. You can this by clicking START > SETTINGS > CONTROL PANEL > ADMINISTRATIVE TOOLS > SERVICES . Find the service called ' Distributed Transaction Coordinator ' and RIGHT CLICK (on it and select) > Start .