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.

1 Answer 1

2

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

3
  • 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, 2017 at 4: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, 2017 at 10:30
  • I had written before mrdenny comment: "Supported but maybe not fully enabled. See this Stack Overflow 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, 2017 at 18:14

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .