Feb 07

Grant xp_cmdshell to user

Today’s topic is regarding the xp_cmdshell feature. There are certain circumstance that require xp_cmdshell to be used, even though there are inherent security risks. Here are some MSDN articles that provide some insight into xp_cmdshell and some example uses:

Now to the good stuff:

  1. Ensure that xp_cmdshell is enabled on your server
  2.  Grant the xp_cmdshell permission to the user:
  3.  Configure a xp_cmdshell proxy account. This account should have the CONTROL SERVER securable assigned: