title: How to grant permissions to SqlServer 2005 system stored procs (e.g. sp_start_job)
body: <p>I want to be able to invoke an SSIS package at will from a web application.  I've found that I can do this successfully with sp_start_job when running on my local machine.  However, when I publish to our test site, I get:</p>
  
  <pre><code>The EXECUTE permission was denied on the object 'sp_start_job', database 'msdb', schema dbo'
  </code></pre>
  
  <p>So I tried this </p>
  
  <pre><code>USE msdb
  
  CREATE USER [TheUser] FOR LOGIN [TheLogin]
  GO
  
  GRANT EXECUTE ON sp_start_job TO [TheUser]
  GO
  </code></pre>
  
  <p>However, after running this, I am still getting the permission denied error.  Is there something special you have to do to grant permissions to system stored procs?</p>
  
  <p>Edit: don't know if it makes a difference or not, but the Webserver is in a DMZ, so I am using sql server authentication to communicate between webserver and db server.</p>