sql server clustering: DTSRUN using MSDTC must run under Cluster Admin account? -- sql server clustering

DTSRUN using MSDTC must run under Cluster Admin account?

micl NO[at]SPAM hkstar.com
10/19/2004 6:46:58 PM

sql server clustering: 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

RE: DTSRUN using MSDTC must run under Cluster Admin account?

Mike Epprecht (SQL MVP)
10/19/2004 10:41:03 PM

Hi

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

Regards
Mike

[quoted text, click to view]

Re: DTSRUN using MSDTC must run under Cluster Admin account?

micl NO[at]SPAM hkstar.com
10/21/2004 12:32:22 AM

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=cluster+admin+dtc&hl=zh-TW&lr=&group=microsoft.public.sqlserver.*&selm=ePVOrlOfAHA.1784%40tkmsftngp05&rnum=1

Please continue to provide assistance.

Thanks,
Michael Leung

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server clustering group.