Adsense

Monday, June 02, 2008

MSDTC on server 'SERVER NAME' is unavailable

MSDTC Error

You might encounter this error when trying to interact with a Microsoft SQL Server whose hosting environment doesn't have the Distributed Transaction Coordinator service turned on. To correct this problem, turn on the Distributed Transaction Coordinator service on the server hosting your SQL Server instance using the following steps.

  1. Press your 'Windows Key + R' to bring up the run window
  2. Enter 'Services.msc' in the run box and press ENTER
  3. Look for the service named 'Distributed Transaction Coordinator' and right click on it.
  4. Click on 'Start'

Services

The service should now be started, and if the SQL Gods smile upon you, your error should be gone.