After I'd given the user access to EXECUTE xp_cmdshell I placed the following in a stored procedure:
EXEC master.dbo.xp_cmdshell 'dtsrun /S "LCIRPTSRV\LCI_DEV" /E /N EST_MY_DTS';
I placed this in an Access Project for my user to run an this is the error:
xp_cmdshell failed to execute because current security context is not sysadm and proxy account is not set up correctly. For more info....topic related to xp_sqlagent_proxy_account
What should be my next step? and HOW do I make the stored not available to view if I am to set-up the stored procedure with a username and password?