denied permission to run CmdExec

I have created a DTS package and scheduled a job ofr it.
I then used sp_start_job on the Query Analyzer to start the job. The message indicates that the job has started successfully.
I then checked the job histoy and found the following errors

Step ID 0
The job failed.  The Job was invoked by User <NAME>\<my user name>.  The last step to run was step 1


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

I have public access to msdb database.Am I missing anything else?
Thanks
ams7503Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

adwisemanCommented:
When you schedule a job to run, the job runs under the credentials that the SQL Server Agent in the server is running under, not the credentials of the person who scheduled the job.  Usualy this is the same user that SQL Server Service is running under.  This user needs permission to perform all functions being executed.  I'm guessing that CmdExec is a step that executes a dos command, using xp_cmdshell.  This Extented SP in the Master database is often disabled due to it's security risks.  Check that the SQL Agen user has rights to execute this

An easy test is
Exec master..xp_cmdshell 'dir'
and see if you get a dir listing back from dos
0
ams7503Author Commented:
Thanks for the feedback
I think the problem must be because, i own the package but do not have sysadmin privilges, i have read up on setting a proxy account which would then enable the package to execute.

However, how does one set the proxy account? I am not sure what the domain should be?
0
adwisemanCommented:
The same domain that the Server Resides in.  How to set it up, I'm not sure.  Sounds like a job for the System administrator of the server.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ams7503Author Commented:
thanks!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.