Permissions Nightmare. Urgent

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Aashu (anonymous_at_discussions.microsoft.com)
Date: 02/28/05 

Date: Mon, 28 Feb 2005 06:57:26 -0800

Please help !

We have a DTS which loads files using FTP to another
server. This will be used by app groups and will be run
via click of button using sp_start_job,

Somehow the userid running the job gets "not sysadmin to
run cmdshell.." Top fix that, we granted it to execute the
xp_cmdshell and also created a proxy account for SQL Agent
which is an admin on server and sql. However, still we get
permission errors like "...The needed permission is
missing to run command shell.." Please help . The DTS is
being called from SQl Agent job and we don't want an admin
ID to be used .

Thanks

Quantcast