Good morning,

I'm writing a transactional dts using Execute SQL Tasks and Data
Driven Query Tasks to move data between 2 servers.

Working from my own workstation with a Login that I know has no Server
Roles defined, but does have Access Rights up to db_owner, I
continually get ...Does not support joining distributed transactions
or failed when attempting to join - New transaction cannot enlist in
the specified transaction coordinator in the first step, which is
using only an Execute SQL Task on the local server connection.

Running from the console on the local server, the first step
completes, but the second (the Data Driven Query Task) fails with
similar error messages.

The Login on the connection to the remote server is known to have
lower authority than the local connection, but still has authority to
Create, Read, Update and Delete records and tables.

I'm guessing that since the DTS is server wide, it's the lack of
Server Roles that causing the problem, but need to know what the
minimum requirement is to get the two talking to each other. It would
also be a big help if I could develop and run from my local
workstation instead of the server console.

Any help greatly appreciated.

Duncan Spence

I doubt the roles are acually playing any part in this whatsoever

Have a look at these pages

http://www.google.com/search?sourcei...list+in%22+DTS

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Duncan Spence" <spence_duncan (AT) hotmail (DOT) com> wrote