sql-servertransactionswindows-servermsdtcserver-core

Enabling and Configuring MS DTC on Windows Server Core machines


Since we do distributed transactions using Entity framework, we currently have DTC enabled on both the client/server and the SQL server boxes in all environments.

This was easy to set up using using How to Enable MSDTC on a Web Server and it works well.

However our production environment's use Windows Server Core and this is a rudimentary command line based environment.

How do I enable/configure MS DTC on the Windows Server Core machines?


Solution

  • From another computer, you can:

    Powershell

    From Server Core Powershell window or using a remote Powershell session you can use MS DTC cmdlets: Distributed Transaction Coordinator (MSDTC) Cmdlets in Windows PowerShell

    You have to figure out which one are needed based on your requierement.

    You can for example use Set-DtcNetworkSetting in order to modify network and security configuration for a DTC instance.