Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Unable to enlist in transaction

Author  Topic  millross Starting Member 1 Post Posted - 2006-11-21 : 12:50:28 Hi there, I have a DTS package which is setup to join a transaction if present (on all package steps) and to rollback on failure (again on all package steps) I am trying to run this DTS package with a set of Data transformation tasks, between a Windows 2000 server/Sql Server 2000 and another Windows 2000 server/Sql Server 2000. Both machines have MSDTC service started. When I try and run the DTS package using the designer, or DTSRunUI (With Global vars populated) the very first item fails and states "Unable to enlist in transaction" - "New transaction cannot enlist in the specified transaction coordinator". I have found numerous threads based on tweaking Windows Server 2003 to fix this, but nothing for Windows 2000. I'm really a .NET developer and not a DBA, so im not sure where to look next. Any help greatly appreciated! Matt