Can someone tell me how to fix this error? I am trying to put this website in production using SQL server 2005. I even followed the instructions on imar.spaanjaars.com/quickDoeId.aspx?quickdoc=395 but nothing is working right.

I set all the execute permissions on all stored procedures for the ASPNET user in SQL server 2005.

Server Error in '/SendItNow' Application.
--------------------------------------------------------------------------------

The EXECUTE permission was denied on the object 'sprocResourceInsertUpdateItem', database 'FILESHAREDB.MDF', schema 'dbo'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'sprocResourceInsertUpdateItem', database 'FILESHAREDB.MDF', schema 'dbo'.

Source Error:


Line 42: 'open the connection and execute the stored procedure
Line 43: mConnection.Open()
Line 44: mResourceID = mCommand.ExecuteScalar()
Line 45: mConnection.Close()
Line 46:


Source File: H:\MIS Department\Intranet\SendItNow\App_Code\Dal\Resourc eDB.vb Line: 44

my connection string is :

  <add name="ConnectionString"
       connectionString="Data Source= MISFS;Initial Catalog=FILESHAREDB.MDF;
       Integrated Security=true;"
   providerName="System.Data.SqlClient" />

Any help is appreciated. I have been trying to get this up and running since friday.

I finally got this working now. I had to set execute permissions for the user NT AUTHORITY.