sql server dts: DTS/Agent job fails because denied permission -- sql server dts

DTS/Agent job fails because denied permission

Tom
9/14/2004 11:43:44 AM

sql server dts:

Newby (power user) at the controls here. I am trying to
set up a job that will import data from an IBM AS400
system using DTS & Sql Agent. Our DBA cannot seem to
find the problem or will not figure it out.

I work on a remote workstation. Not directly on the
server. I can schedule and set up jobs, but they do not
execute. I get the following:

"Non-SysAdmins have been denied permission to run CmdExec
job steps. The step failed."

The DBA says I have SysAdmin access. Could it be my
Windows network security that is causing the problems? I
have seen some references in KB about this.

Can anyone provide some guidance so I can proove to our

Re: DTS/Agent job fails because denied permission

Allan Mitchell
9/14/2004 11:37:12 PM

When you schedule a DTS package it is not you that runs it.

Have a look here

http://support.microsoft.com/?kbid=269074

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

[quoted text, click to view]