Stored Procedure Execute Permission For ASPNET?

I'm trying to get a stored procedure working for a website on my local machine that uses ASP.NET 1.1 and MSDE. (I have a single instance of the latter installed, using Windows Authentication mode.)





I've been able to run SQL queries and such directly (using SqlCommand and so forth) by adding the proper reader role to the account MACHINENAMEASPNET. (Substituting my actual machine name for MACHINENAME, of course.) However, when I try to run a stored procedure from an .aspx page, I get the following error:





System.Data.SqlClient.SqlException: EXECUTE permission denied on object 'MySPName', database 'mydbasename', owner 'dbo'.





I've researched this problem here and other places, and every time I get to a response that says to grant execute permission (via OSQL -E) with the following statements:





use mydbasename


go


grant execute on MySPName to MACHINENAMEASPNET


go





(There are sometimes some other intervening statements to add ASPNET as a user account, but when I use those I'm told that the account already exists ... I had added it previously via the Web Data Administrator in order to get reader permissions for SELECT statements and so forth.)





My problem is that the GRANT EXECUTE statement always fails with the following error:





Line 1: Incorrect syntax near ''





Using a forward slash instead doesn't make any difference. If I put single quotes around 'MACHINENAMEASPNET', then the error changes to:





Line 1: Incorrect syntax near 'MACHINENAMEASPNET'





And if I eliminate the machine name, then the error is:





Msg 4604, Level 16, State 1, Server MACHINENAME, Line 1


There is no such user or group 'ASPNET'





So can someone please let me know what I am missing that doesn't allow the GRANT EXECUTE to work?





Here is the stack trace (note that I have altered some names and paths for purposes of security):








[SqlException: EXECUTE permission denied on object 'MySPName', database 'mydbasename', owner 'dbo'.]


System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723


System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +194


ASP.Login_aspx.MySPName(String str1, String str2) in C:Inetpubwwwrootloginlogin.aspx:43


ASP.Login_aspx.Button_Click(Object s, EventArgs e) in C:Inetpubwwwrootloginlogin.aspx:20


System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108


System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57


System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18


System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33


System.Web.UI.Page.ProcessRequestMain() +1277








Thank you in advance for any assistance!