?
Solved

EXECUTE permission denied on object 'sp_makewebtask'

Posted on 2004-10-05
3
Medium Priority
?
1,754 Views
Last Modified: 2012-08-14
Hello,

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
0
Comment
Question by:osit
3 Comments
 
LVL 15

Expert Comment

by:jdlambert1
ID: 12228165
>This is the first time i have even encountered sp_makewebtask
Something is attempting to call/use sp_makewebtask. View the code in the procedures that produce the error and find the reference to see what it trying to do. If you didn't alter the sp code, is anyone else authorized to change it?
0
 
LVL 2

Expert Comment

by:doswell
ID: 12228857
I'd check the permissions the app is running under and what it's using to connect to the DB,

also info on that makewebtask SP;
 http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ma-mz_2p0r.asp
 http://www.mail-archive.com/pen-test@securityfocus.com/msg00310.html

0
 
LVL 1

Accepted Solution

by:
kewllover earned 2000 total points
ID: 12228913
Chances are your there is a trigger on the table that updates a cache object in your web application that caches a dataset in memory whenever the datachanges on the database.  When that stored procedure attempts to execute it cannot find the specified machine/file on the network and fails or it fails because your username doesnt have permissions to update that file on that machine.

Hope this helps Haider!
:D
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Jet database engine errors can crop up out of nowhere to disrupt the working of the Exchange server. Decoding why a particular error occurs goes a long way in determining the right solution for it.
If you try to migrate from Elastix to Issabel, you will face a lot of issues. These problems are inevitable but fortunately, you can fix them. In the guide below, I will explain how I performed the migration while keeping all data and successfully t…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

588 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question