MSDTC Distributed Transaction Coordinator Enabling

Posted by Curtis White on Stack Overflow See other posts from Stack Overflow or by Curtis White
Published on 2011-02-24T16:45:38Z Indexed on 2011/03/12 16:10 UTC
Read the original article Hit count: 266

Filed under:
|
|
|

I've a web server and a separate SQL server. I'm trying to use transaction scope to ensure that SQL queries are completed with my linq queries.

I wrap everything with this

using (TransactionScope scope = new TransactionScope())

I want to know where I need to install DTC. Do I need to install it on the IIS 7.5 box AND the SQL server? Do I need to unblock some ports? Are there any security risk in doing so?

I've setup this up once before but don't remember how. If I can't get access to DTC then is there any other way to ensure a lINQ and sql query is atomic?

© Stack Overflow or respective owner

Related posts about ASP.NET

Related posts about sql-server