title: Executing stored procedures is not allowed
body: <p>I wrote a stored procedure for my application &amp; can successfully run it in on my local. But while running the same application live it's throwing an error:</p>
  
  <blockquote>
    <p>Executing stored procedures is not allowed</p>
  </blockquote>
  
  <p>Issue return while run the site.</p>
  
  <p>This is my sample code :</p>
  
  <pre><code>&lt;cfstoredproc procedure="countUsers" datasource="myDataSource" debug="yes" result="countResults"&gt;
      &lt;!--- ClientID ---&gt;
      &lt;cfprocparam cfsqltype="cf_sql_integer" value="#customerID#" type="IN"&gt;
      &lt;!--- LoggedInNow ---&gt;
      &lt;cfprocparam cfsqltype="cf_sql_bit" value="1" type="IN"&gt;
      &lt;cfprocresult name="qUsers" maxrows="5"&gt;
  &lt;/cfstoredproc&gt;
  </code></pre>
  
  <p>While dump the query result it's return data. But while test with live site it's return the below issue,</p>
  
  <p><a href="https://i.stack.imgur.com/QCx5l.png" rel="noreferrer"><img src="https://i.stack.imgur.com/QCx5l.png" alt="enter image description here"></a></p>
  
  <p>Note: But I can directly run the procedure in SQL Server directly with my same login.</p>
  
  <p>Only the difference is in my local using cf11 but the live is in cf18. </p>