[教学] Sql Server 错误ERROR: MSDTC on server 'servername' is unavailable.

[教学] Sql Server 错误ERROR: MSDTC on server 'Instance Name/servername' is unavailable.

去START > SETTINGS > CONTROL PANEL > ADMINISTRATIVE TOOLS > SERVICES. 找service里面有个叫'Distributed Transaction Coordinator' and 右键RIGHT CLICK > 选Start.

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.