EXECUTE permission denied on object 'sp_makewebtask'
Posted on 2004-10-05
I have designed SEVERAL stored procedures from my ASP.NET web application that have work just fine up until 2 days ago when I unexpectedly started recieving this error message upon executing SOME(not all) of the stored procedures in my DB:
System.Data.SqlClient.SqlException: EXECUTE permission denied on object 'sp_makewebtask', database 'master', owner 'dbo'
At first i thought it may have something to do with my vb.net code, but i tried a simple query in the Users table ( update Users set AccountID = 2 where UserID = 2) using sql analyzer, and after 31 seconds of lag, i recieved the following message:
Server: Msg 16821, Level 11, State 1, Procedure sp_makewebtask, Line 125
SQL Web Assistant: Could not open the output file.
The row, however, was updated. This is the first time i have even encountered sp_makewebtask. Is there anyone who knows why this problem may have arised, and how to solve it?
thanks in advance