FIXing : "MSDTC on server 'servername' is unavailable"

Solution:

MSDTC service needs to be turned on in the server where the trigger resides. You can start this service in 2 ways:

1. Start the service from "Run": press ( Windows key+ R )and then type "net start msdtc" and press enter.

2. Go to START > SETTINGS > CONTROL PANEL > ADMINISTRATIVE TOOLS > SERVICES. Find the service called "Distributed Transaction Coordinator" and RIGHT CLICK on it and select Start.

Solving the issue of running MSDTC where the hosting service doesn't support it:
Godaddy.com doesn't support MSDTC in their shared hosting. But, if you want to deploy you web site to their server and you don't have the permission to start that service, the work around is using ";Enlist=false" at the end of your connectionString in webConfig file. For Example:

connectionString="Data Source=sunnyhasan.resource.com;Initial Catalog=sunnyhasan;User ID=sunnyhasan;Password=scars123;Enlist=false"