Re: using transaction on DTS package

#1

Seems like SQL Server is running under local account, try to run SQL
Server/SQL Server agent services under domain account which should be
administrator on local sql server machine.

ashish

"I Cheung" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

I am having some problem using transactions on a DTS package.

The DTS package have serveral ExecuteSQL tasks and they are set up in
sequence and use transactions. If any of the step fails, the transcation

will roll back and the package fails.

Quote:

The Distributed Transaction Coordinator service has been started.

Everytime when I run this package, it failed step 1 and it generated an
error as such:

A connection with the transaction was lost. Connection 'Dev SQL Server'
for Task 'DTSTask_DTSExecuteSQL_Task1' does not support joining distributed

transaction or failed with attempting to join. A connection with transaction
manager was lost. MSDTC on server is unavailable.

Quote:

It seems like it is related to the security setting and SQL Server cannot
communicates to the DTC. However, I cannot pinpoint where the problem is.

Any idea? Thank you.

I Cheung

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: using transaction on DTS package

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: using transaction on DTS package - 01-29-2004 , 09:40 PM