Hi Cesar,

You need to add this account as a "user" in the master db.
Then go the "stored procedures" in master db
Find "xp_cmdshell" and double click it
Click on "permissions"
Find your sql server login account and grant him/her "execute" permission
for this particular extended procedure.

Of-course you can do it all using t-sql, but, above method is easy for you.

Regards,
Uday

-----Original Message-----
From: cesaralt
[mailto:mssqldba-ezmlmshield-x89163693.[Email address protected]
Sent: Wednesday, 25 August 2004 9:32 AM
To: LazyDBA Discussion
Subject: Permission to run CmdExec job steps

Hi,
I am trying to run a scheduled DTS Package and I got the following message:
"Non-SysAdmins have been denied permission to run CmdExec job steps. The
step failed."

How Do I assign permissions to users to run DTS job
steps?
Thanks for any help.

Regards,
Cesar Altamirano


---------------------------------------------------------------
EC Red Internet [Email Address Removed] en www.ec-red.com


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]


MS Sql Server LazyDBA home page