XP_CMDSHELL Nightmares...

So you have tried everything and you still get the dreadfull error:

An error occurred during the execution of xp_cmdshell. A call to 'CreateProcessAsUser' failed with error code: '1314'

Nothing in the world of GOOGLE has fixed your issues.

You have given all the rights to the user executing the xp_cmdshell and still no luck.

Here is a little statement I pulled off the web to help you test as you mess with permissions on the user that cant execute xp_cmdshell

--Run as login x
EXECUTE AS login = 'Domain\User'
--Below fails, no execute permission on xp_cmdshell
EXEC xp_cmdshell 'DIR C:\*.*'
REVERT
GO

1. Did you grant Execute rights on XP_CMDSHELL to ''Domain\User' ?
2. Did you add Domain\User to the Master db?
3. Did you create a proxy account for non-sysadmins using sp_xp_cmdshell_proxy_account?
4. Did you make sure xp_cmdshell is enabled using EXEC sp_configure 'xp_cmdshell', 1 ?

If you did all of this and you still get the same error:

An error occurred during the execution of xp_cmdshell. A call to 'CreateProcessAsUser' failed with error code: '1314'

Add the user in question to the SysAdmin role and then try it again.

That was the ONLY thing that worked for us and this included 1 day of 2 DBA, 2 Developers, 1 SysAdmin and 1 Data Architect.

Guess thats why we make the big bucks eh???