3

I need MSDTC(Microsoft Distributed Transaction Coordinator) in one of my application. I am not sure whether it is available on Sql Server Express editions.

I googled on MSDN and haven't got clear answer on this. It seems with googling that it is avaialble but not started when sql server is installed.

Shantanu Gupta
  • 219
  • 1
  • 8

1 Answers1

2

Yes, distributed transactions are supported on all editions of SQL Server.

mrdenny
  • 27,074
  • 4
  • 40
  • 68
  • It's fully supported and enabled in all editions of SQL Server. If you have a document that shows otherwise, I'd love to see it. – mrdenny Feb 21 '17 at 04:33
  • We may not understand the same thing by enabled, but I had to enable remote access on my setup (win10 home + sql server express 2016) as illustrated is the link provided in my previous comment. Sure, this is not a document, just personal experience. – Frédéric Feb 21 '17 at 10:30
  • I had written before mrdenny comment: "Supported but maybe not fully enabled. See this [Stack Overflow](http://stackoverflow.com/a/30959127/1178314) answer if in need of enabling remote access by example." Sorry for the initially broken link. Now it is fixed. – Frédéric Feb 27 '17 at 18:14