SQL2K CmdExec Proxy Account Setup

Hi, I have the following setup:

- Win 2K Server, SP4
- SQL Srv 2K, SP4
- A 'DEV' domain, with an 'Administrator' account with all possible rights on the system

I need to configure a CmdExec proxy account in order to allow non-sys-admin users to execute the master.dbo.xp_CmdShell procedure.

When attempting to do this via QA as follows:


EXEC master.dbo.xp_sqlagent_proxy_account N'SET',
N'DEV', -- agent_domain_name
N'Administrator', -- agent_username
N'password' -- agent_password

...I get the following error:


"The system cannot find the path specified."



When attempting to do this via QA as follows (note: only change is adding domain to agent_username arg):


EXEC master.dbo.xp_sqlagent_proxy_account N'SET',
N'DEV', -- agent_domain_name
N'DEVAdministrator', -- agent_username
N'password' -- agent_password

...I get the following error:


"Error executing extended stored procedure: Specified user can not login"




I have tried this through Enterprise Manager and get identical results, of course.

I have also tried all of the following:
- different OS user accounts, including local system accounts with local admin rights;
- assigning the OS account to a SQL login with System Admin role/rights;
- specifically assigning the above SQL login with EXEC rights on the master.dbo.xp_CmdShell procedure;
- verifying local security policy settings, as per the following link: http://support.microsoft.com/?id=283811;
- pulling out my hair and banging my head against the wall.

Can anyone H E L P ? ! ! !

Thanks,

Joe