sp_makewebtask and security

• paulgibson

  Valued Member

  Points: 59

  More actions

  November 15, 2005 at 12:21 am

  #111333

  Is it possible to run sp_makewebtask without being a member of the sysadmin role using sql2k SP4?

  I have tried creating a custom stored proc based on the sp_makewebtask and commented out the sysadmin check, but I still receive the error: "SQL Web Assistant: Could not open the template file".

  When I run the same custom stored proc as a sysadmin, it all works fine, as expected.

  I'm pretty sure this same process used to work prior to SP4, so any ideas to work around this security issue will be much appreciated.

  Paul.

• mimorr

  SSCarpal Tunnel

  Points: 4850

  More actions

  November 16, 2005 at 8:58 am

  #604222

  I saw this error when the user I was signed on as in SQL Server didn't have read rights to the template file on the web server.

  
  
  Michelle