I have W2KAS, SQL Server 2000 active/passive cluster with cluster
MSDTC resources.

I use NT Task to execute DTS package via DTSRUN and package requires
transactions. If the task is run as administrator or a account with
cluster administrive right, everything is fine. Otherwise, I will get
the following error in the event log and the package is not run and
without any log.

Is there any way such that I don't have to run the NT task with
administror or cluster administrive rights?

The application log shows an event 4376 from the MSDTC client:
Event Type: Error
Event Source: MSDTC Client
Event Category: (16)
Event ID: 4376
Date: 10/04/2002
Time: 12:40:34
User: N/A
Computer: KANE
Description:
The application could not connect to MSDTC because of insufficient
permissions. Please make sure that the identity under which the
application
is running has permission to access the cluster. Please refer to MSCS
documentation on how to grant permissions.

Hi

Make sure that the account you are trying to use has at minimum "log on
locally" rights.

Regards
Mike

"Michael Leung Kim Ming" wrote:

Mike,

Actually, I logon as the account, invoke enterprise Manamager,
highlight the DTS package and execute. I can't do that without "log on
locally" rights.

I have searched Google and there are many posts in the past reporting
this. e.g.

http://groups.google.com.hk/groups?q...ftngp05&rnum=1

Please continue to provide assistance.

Thanks,
Michael Leung


"Mike Epprecht (SQL MVP)" <mike (AT) epprecht (DOT) net> wrote