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

From: Michael Leung Kim Ming (micl_at_hkstar.com)
Date: 10/21/04 

Date: 21 Oct 2004 00:32:22 -0700

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

"Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message news:<08A734A7-83D1-4D6A-A573-5E5121CCB9BF@microsoft.com>...
> 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:
>
> > 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.
> >

Relevant Pages

  • Re: SQL Server 2005 Stored Procedure security annoyances
    ... Can you grant an EXECUTE permission on stored procedure? ... I have came to the maturity level to stop using the sa account when I ... I mean it is unrealistic to have to manually set for each SP the rights ...
    (microsoft.public.sqlserver.security)
  • Cross post recommended on this seemingly sinple problem
    ... >I have an ActiveX Script task in a DTS package which executes fine ... Why does the scheduled job not execute ... > schedule and the account is a domain account with windows ... even with both the package and the job owned by the same account (I ...
    (microsoft.public.sqlserver.dts)
  • Re: installing mod_python -- sharing experiences
    ... rights are granted to whatever account the apache ... service is run under to read and execute not only in the ... import mod_python.apache`` in the apache errors log ... service account to administrator (provided you have the ...
    (comp.lang.python)
  • Re: trying to run executable on server
    ... your account has rights to execute it? ... you have an arguments in the string ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Executing DTS from Code (correction)
    ... > Granting execute permision to the sp_XOA..... ... >> Ok so who will be executing the VB.Net code on the server? ... >> Get that account and log in to the server as that account. ... >>> runs the DTS package. ...
    (microsoft.public.sqlserver.dts)