I tried that. I gave Public and webuser both execute permission. It didn't change anything. Enclosed if the full error message with the Stack Trace: Server Error in '/BenefitsVB' Application. --------------------------------------------------------------------------------
EXECUTE permission denied on object 'TempGetStateItemExclusive2', database 'ASPState', 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 'TempGetStateItemExclusive2', database 'ASPState', owner 'dbo'. Source Error: An unhandled exception was generated during the execution
of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [SqlException: EXECUTE permission denied on object 'TempGetStateItemExclusive2', database 'ASPState',
owner 'dbo'.] System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) System.Data.SqlClient.SqlCommand.ExecuteReader() System.Web.SessionState.SqlStateClientManager.DoGet(String id, SqlCommand
cmd) [HttpException (0x80004005): Unable to connect to SQL Server session database.] System.Web.SessionState.SqlStateClientManager.DoGet(String id, SqlCommand cmd) System.Web.SessionState.SqlStateClientManager.GetExclusive(String id) System.Web.SessionState.StateClientManager.BeginGetExclusiveSync(String
id, AsyncCallback cb, Object state) System.Web.SessionState.SqlStateClientManager.System.Web.SessionState.IStateClientManager.BeginGetExclusive(String id, AsyncCallback cb, Object state) System.Web.SessionState.SessionStateModule.GetSessionStateItem() System.Web.SessionState.SessionStateModule.BeginAcquireState(Object
source, EventArgs e, AsyncCallback cb, Object extraData) +271 System.Web.AsyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() +66 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +173
Price
Member
75 Points
15 Posts
Re: SQL Server Error Returned
Mar 03, 2005 07:21 PM|LINK