sql server dts: Permissions Nightmare. Urgent -- sql server dts

Permissions Nightmare. Urgent

Aashu
2/28/2005 6:57:26 AM

sql server dts: 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 .

Re: Permissions Nightmare. Urgent

Sue Hoegemeier
3/1/2005 9:26:36 PM

Did you also configure SQL Agent to allow non-sysadmins to
execute CmdExec and ActiveX scripting jobs? Check the
setting on the Job System tab of the SQL Agent properties
window.
You can also verify that the proxy account is set with:
EXEC master.dbo.xp_sqlagent_proxy_account N'GET'

-Sue

On Mon, 28 Feb 2005 06:57:26 -0800, "Aashu"
[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 dts group.