Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2002
    Posts
    229

    Unanswered: xp_cmdshell execute rights (2005)

    I was trying to grant access for an application user for executing xp_cmdshell, but I got some error message saying that either doesn't the user exist, or I don't have the permissions to grant this. Does the user need to be a user in Master ? Or, don't I when logged in as "sa" have the sufficient permissions to grant execute on a SP in master?

    I solved it by checking "Control server" under "Properties" > "Securables"
    for the login, but I don't actually want this login to have full control.

    (And yes, I've read that allowing xp_cmdshell usage isn't recommended at all.)

  2. #2
    Join Date
    Nov 2004
    Posts
    128
    By default xp_cmdshell is disabled, and must be enable through the Surface Area Config tool.

  3. #3
    Join Date
    Jul 2002
    Posts
    229
    Yes, it's enabled, so I'm through that part.

  4. #4
    Join Date
    Nov 2004
    Posts
    128
    Tis seems to be much different than 2000, but try SQL Server Agent/ Proxies/ OS (CmdExed). Let us know what happens.

Posting Permissions

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