SQL Server Desktop User! Please Help![Resolved]
I am trying to work with a local copy of my data in the sql server desktop engine. I have ASP.Net Added as a user. But I am still getting the error.
Server Error in '/pkpromo-002' Application.
--------------------------------------------------------------------------------
EXECUTE permission denied on object 'ProductPhases_GetProductPhaseByProductPhaseName', database 'pkpromo', owner '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: EXECUTE permission denied on object 'ProductPhases_GetProductPhaseByProductPhaseName', database 'pkpromo', owner 'dbo'.
Source Error:
Line 227:
Line 228: conn.Open();
Line 229: ret = cmd.ExecuteScalar();
Line 230:
Line 231: conn.Close();
Source File: E:\Visual Studio Projects\PKPromo.Data\Helpers\SqlProcedure.cs Line: 229
Stack Trace:
[SqlException: EXECUTE permission denied on object 'ProductPhases_GetProductPhaseByProductPhaseName', database 'pkpromo', owner 'dbo'.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
System.Data.SqlClient.SqlCommand.ExecuteScalar()
PKPromo.Data.Helpers.SqlProcedure.ExecuteScalar(String procedure, SqlParameter param, String connection_string) in E:\Visual Studio Projects\PKPromo.Data\Helpers\SqlProcedure.cs:229
PKPromo.Data.Products.ProductPhase.GetPhaseKey_ByPhaseName(String name) in e:\visual studio projects\pkpromo.data\products\productphase.cs:113
PKPromo.Web._Default.Page_Load(Object sender, EventArgs e) in e:\my wwwroot\pkpromo-002\default.aspx.cs:14
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
Please help
