title: Calling web service from SQL Server stored procedure gives execute access denied (IIS Error)
body: <p>I have created a stored procedure which calls a web service using <strong>Ole Automation Procedures.</strong></p>
  
  <p>When I call it from one database server it does allow me to call web service, but when I call it from another database server it does not allow me to call web service and throws this response.</p>
  
  <p>I can't figure out where the problem is :</p>
  
  <blockquote>
    <p>The page cannot be displayed</p>
    
    <p><strong>You have attempted to execute a CGI, ISAPI, or other executable program from a directory that does not allow programs to be executed.</strong></p>
    
    <p>Please try the following:   </p>
    
    <p>Contact the Web site administrator if you believe this directory should allow execute access.</p>
    
    <p>HTTP Error 403.1 - <strong>Forbidden: Execute access is denied.</strong><br>
    Internet Information Services (IIS)</p>
    
    <p>Technical Information (for support personnel)  </p>
    
    <p>Go to <a href="http://go.microsoft.com/fwlink/?linkid=8180" rel="nofollow">Microsoft Product Support Services</a> and perform a title search for the words <b>HTTP</b> and <b>403</b>.</p>
    
    <p>Open IIS Help, which is accessible in IIS Manager (inetmgr), and search for topics titled Configuring ISAPI Extensions, Configuring CGI Applications, Securing Your Site with Web Site Permissions and About Custom Error Messages</p>
    
    <p>In the IIS Software Development Kit (SDK) or at the <a href="http://go.microsoft.com/fwlink/?LinkId=8181" rel="nofollow">MSDN Online Library</a>, search for topics titled <b>Developing ISAPI Extensions</b>, <b>ISAPI and CGI</b>, and <b>Debugging ISAPI Extensions and Filters</b></p>
  </blockquote>
  
  <p>Any help is appreciated..</p>
  
  <p>thanks</p>