Hi Friends,
I have a SQLServer Job that try to execute a command
DTSrun using the proc xp_cmdshell, but I receive "Access
Denied" when the DTSrun are executed

my configuration:
SQL Server 7.00 - 7.00.1063 (Intel X86) - SP4
Windows 2000 - Service Pack 4

Someone can help me ?

thx
Johnny

Hi,

The security context in which the job is run is determined by the owner of
the job. If the job is owned by a login that is not a member of the Sysadmin
server role, then the package is run under the context of the SQLAgentCmdExec
account and has the rights and permissions of that account.

For SQLAgentCmdExec to be able to run jobs that connect to SQL Server, the
SQLAgentCmdExec account must have proper Windows/NT permissions and be
granted login access to SQL Server with appropriate database permissions. The
SQLAgentCmdExec account generally has no rights outside of the local SQL
Server computer. Therefore, any package that requires a connection to another
computer fails, if it is scheduled as a job owned by a login that is not a
member of the Sysadmin role.

For more information:
http://support.microsoft.com/?id=269074


"Johnny Silvestre" wrote: