Distributed Transaction Coordinator

Customer Support Customer Only Discussion
1

Hello,

My client needs to use transactions and DTC - can we use this at MSSQL10.
My client claims that every serious web application needs transactions and he gets error: The transaction manager has disabled its support for remote/network transactions .

Thanks,

Uggs

2

No we don’t allow it, PCI standards do not allow it to be on.

3

Thanks Stephen! Do you know if is it possible to use transactions without DTC? it seems DTC is needed when database and web servers are on different phisical servers.

Threesome Bathroom

4

Most of the time it’s enough to use transactions for certain database operations. You can still include transactions in stored procedures and SQL statements.

I think you can also use the .NET System.Transactions functionality, as long as your transaction encompasses only a single resource, for example a single database.

Shame DTC isn’t supported though.. and I’m somewhat puzzled by the reasoning behind this PCI compliance thing.