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.
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.
( or Change the Startup type into Automatic and Right Click and Restart the service )
To do this, type the following command at a command prompt, and then press ENTER:
net start msdtc
Verify that a message is displayed that indicates that the MSDTC service was started successfully.
Post a Comment
Thanks for your views.....