By default, when a stand-alone instance of Microsoft SQL Server exists in a cluster environment, the SQL Server-based instance is set to start automatically. If the host node is rebooted, you may receive the following error message when you issue commands that are related to distributed transactions:
ERROR: MSDTC on server 'servername' is unavailable.
Solution:
- Open (START > SETTINGS > CONTROL PANEL > ADMINISTRATIVE TOOLS > SERVICES).
- Find the service called 'Distributed Transaction Coordinator' and RIGHT CLICK (on it and select) > Start
- If you need change the Startup Type to Automatic so that you don't have to do it when you restart your computer
Cheers :)
