hi everyone,

I have made a DTS-package with transactional behaviour, and a rollback
if one step fails.

I've tested this package between two server in my domain and it
executes without errors.

Now I'm trying to run the package between two servers in different
domains, and I get an error :

Connection 'CoramServer' for task 'DTSTask_DTSDataDrivenQueryTask_8'
does not support joining distributed transactions or failed when
attempting to join. New transaction cannot enlist in the specified
transaction coordinator.

What can be the cause of this error ?

Is it because now the connection is over TCP/IP in stead of Named
pipes ?
Is it because of the different domains ?

What might be the solution of this problem ? I assume it must be
possible to use transactions even over TCP/IP ?

Both servers have MSDTC running.

Thanx for any help !

Koen

If you search the MS KB there are plenty of articles about this error. Key
things to look out for is that the correct ports are open between the
machines, and there is net bios name resolution between all machines. The
latter was what caused me the most difficult in cross domain distributed
transactions. WINS or LMHOSTS can be used to solve the name resolution
issues.


--
Darren Green
http://www.sqldts.com



"Koen Appeltans" <koen (AT) sdt-informatics (DOT) be> wrote