MSDTC is disabled by default (windows 2003 - onwards) and I want to have it enabled for an application I'm developing that requires distributed transactions from .Net C#. I don't believe there are any security issues with enabling it, but does SO know of any security issues with enabling the DTC? Cheers Ollie ...
Background: I am aware of this SO question about Transactional NTFS (TxF) and this article describing how to use it, but I am looking for real-world experience with a reasonably high-volume enterprise system where lots of blob data (say documents and/or photos) need to be persisted once transactionally and read many times. We are expe...
While creating an SSIS package for SQL Server 2008 i run into the following error: Error: The SSIS Runtime has failed to start the distributed transaction due to error 0x8004D01B "The Transaction Manager is not available.". The DTC transaction failed to start. This could occur because the MSDTC Service is not running. I...
We are using MSDTC for SQL transactions. I am having issue with setting up firewall for MSDTC to work. The application and SQL are running on separate machine. Currently MSDTC is working if i turn off firewall on application server. I think there should be someway to add exception to the firewall setting for some ports. So that firewall ...
I am trying to configure MSDTC for some production machines and am having some difficulty learning what all the settings mean, in particular, "Allow Remote Clients" and "Allow Remote Administration" under "Client and Administration." After hours of searching, this is what I found: New Functionality in [DTC]... - Documents all the se...
I have an app that is saving to a db (using Entity Framework) and saving documents to Sharepoint in a single save. I'm attempting to use MSDTC with a TransactionScope. Part of my EF insert logic includes passing a list of foreign keys to the data layer. The layer retrieves the "foreign key'd" object from the db and then adds it to t...
Is it possible to use the System.Transactions programming model without support for distributed transactions? something like TransactionConfig.DisablePromotion = true; ...
I'm just doing some stat collection on multiple servers, and as a test I'm working with my machine (Machine A) and another machine (Machine B) on the local network. My Machine (A) is collecting all the information in the staging table from the other Machine (B). I have a sp that runs and dynamically creates something like this: exec (...
I have some basic confusion about how transactions and msdtc work together. I have a basic server/client winforms app. The app uses transactionscope to encapsulate several sql commands that are executed on the sql server. The app seemed to work fine when I enabled msdtc network access on the server only. Then one day it stopped working...
From my understanding NServiceBus executes the Handle method of an IMessageHandler within a transaction, if an exception propagates out of this method, then NServiceBus will ensure the message is put back on the message queue (up X amount of times before error queue) etc.. so we have an atomic operation so to speak. Now when if I inside...
Does MySQL support MSDTC? ...
Hi, in our current project we are using ADO.NET Entity Framework as data layer for the application. There are some tasks which require to run in a transaction because there's a lot of work to do in the database. I am using a TransactionScope to surround those tasks. using (TransactionScope transactionScope = new TransactionScope(Transa...
In our project we're using TransactionScope's to ensure our data access layer performs it's actions in a transaction. We're aiming to not require the MSDTC service to be enabled on our end-user's machines. Trouble is, on half of our developers machines, we can run with MSDTC disabled. The other half must have it enabled or they get th...
I am using LINQ to SQL and a third party SDK that supports distributed transactions. When I realize that a pending update will be updating both SQL records and records in the third party SDK, I am creating a TransactionScope with a 0 (presumably infinite) timeout (although I've also tried 12 hours as a timespan parameter). Then I use G...
Hi All, I'm not sure whether it is right to ask it here... I searched the net for an answer, But in vain... So I just wanted to try my luck here. Here is the excerpt from Microsoft Website http://msdn.microsoft.com/en-us/library/ms189322(SQL.90).aspx remote proc trans Option Use the remote proc trans option to protect the act...
I am just starting to work with using TransactionScope, I find that there are always unexpected things I run into that take forever to debug. I figure that having a consolidated list of these would be great for those "weird error" circumstances, plus to expand our knowledge of oddness in the platform. Some context on how I am going to...
To use transaction construct(as follows) in Subsonic, MSDTC needs to be running on Windows machine. Right? using (TransactionScope ts = new TransactionScope()) { using (SharedDbConnectionScope sharedConnectionScope = new SharedDbConnectionScope()) { // update table 1 ...
I have a WCF service that uses ODP.NET to read data from an Oracle database. The service also writes to the database, but indirectly, as all updates and inserts are achieved through an older layer of business logic that I access via COM+, which I wrap in a TransactionScope. The older layer connects to Oracle via ODBC, not ODP.NET. The p...
I have a problem that I know is something local, related to transaction scope, probably MSDTC (I don't know very much about it). The other project developer (same codebase, everything commited) executes the whole solution, but when I try to get some data from the database (not always), I have the following error: The underlying provide...
I receive this error sporadically throughout the day. According to the stack, it's thrown during enlistment. If it were getting this error every time I'd be able to troubleshoot and fix (typically a firewall or LMHOSTS issue). Since it's randomly happening, I can't for the life of me think about what would do this. Any ideas? System...