Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Posts
    1

    Unanswered: Xp_cmdshell / Problem With Proxy Account

    Hello All,
    I have problem with nonsystemadmin user / sql user.
    Permission for sql_user for appropriate procs are OK.
    ____________
    EXEC msdb..sp_set_sqlagent_properties @sysadmin_only = 0
    EXEC master..xp_sqlagent_proxy_account N'SET', N'DOMAIN', N'DOMAINADMINUSER', N'PASS'
    EXEC master..xp_cmdshell 'echo TEST'
    EXEC msdb..sp_set_sqlagent_properties @sysadmin_only = 1
    ____________

    Result set:
    (0 row(s) affected)


    (0 row(s) affected)

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


    (0 row(s) affected)


    (0 row(s) affected)
    _____________
    It seems that setting og proxy account as domain admin user is OK, but still have insufficiency of permission.

    Can You help me with this terrible thing? Please, please...

  2. #2
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    I had the same problem, the user needs to be a user in the master database and execute the commands with master as your current db.

Posting Permissions

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