Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    8

    Angry Unanswered: xpsql.cpp: Error 1314 from CreateProcessAsUser on line 636

    Hi,

    I want to give a non system administrator account permission to execute xp_cmdshell.

    I'm testing it by running this:

    xp_cmdshell 'dir c:\'

    and getting this error

    Msg 50001, Level 1, State 50001
    xpsql.cpp: Error 1314 from CreateProcessAsUser on line 636

    I have a setup a proxy account in SQL Server Agent as instructed - it's the same account that the SQL Server Service is running under.

    I've deselected the 'only users with sysadm privilages...' option in SQL Server Agent properties and I've tried granting a variety of permissions to the proxy account based suggestions I've seen on google. It's a domain account which has local admin rights.

    Other people seem to have found solutions but none of them have worked for me - any siggestions? SQL Server 2k Std Edn and Windows 2003 Server Std Edn.

    Thanks,

    Ian

  2. #2
    Join Date
    Jul 2002
    Posts
    8

    Smile Fixed it

    Switching on 'Allow cross-database ownership changing'. Fixed this!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •