CODEWITHSUNDEEP
sql-servertransactionswindows-servermsdtcserver-core
Gopal SA
Gopal SA

Reputation: 959

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?

Upvotes: 3

Views: 6331

Answers (1)

Julien Vavasseur
Julien Vavasseur

Reputation: 3952

From another computer, you can:

  • run Dcomcnfg.exe
  • rigth click on Console Root / Component Services / Computer
  • select New / Computer
  • add your server

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.

Upvotes: 3

Related Questions