I am receiving the following error when I go to a page in my site. Can anyone assist with how to correct it? Error Message: 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'.
check the permission for this object. I guess its a stored procedure, so you will need to give execute permissions for the dbo user. right click on the stored procedure to set the permissions.
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
OK, I think I found the correct stored Procedure and made the change. Now I receive : Server Error in '/BenefitsVB' Application. -------------------------------------------------------------------------------- SELECT permission denied on object 'ASPStateTempSessions',
database 'tempdb', owner 'dbo'. UPDATE permission denied on object 'ASPStateTempSessions', database 'tempdb', 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: SELECT permission denied on object 'ASPStateTempSessions', database 'tempdb', owner 'dbo'. UPDATE permission denied on object 'ASPStateTempSessions',
database 'tempdb', 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: SELECT permission denied on object 'ASPStateTempSessions', database 'tempdb', owner 'dbo'. UPDATE permission denied on object 'ASPStateTempSessions', database 'tempdb', owner 'dbo'.] System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream) System.Data.SqlClient.SqlCommand.ExecuteNonQuery() System.Web.SessionState.SqlStateClientManager.ResetTimeoutAsyncWorker(String id) [HttpException (0x80004005): Unable to connect to SQL Server session
database.] System.Web.SessionState.SqlStateClientManager.ResetTimeoutAsyncWorker(String id) System.Web.SessionState.SqlStateClientManager.System.Web.SessionState.IStateClientManager.ResetTimeout(String id) System.Web.SessionState.SessionStateModule.OnEndRequest(Object
source, EventArgs eventArgs) +117 System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() +60 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +87 --------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032
Price
Member
75 Points
15 Posts
SQL Server Error Returned
Mar 03, 2005 01:07 PM|LINK
SonuKapoor
Star
13757 Points
2655 Posts
MVP
Re: SQL Server Error Returned
Mar 03, 2005 01:08 PM|LINK
ASP.NET News and Articles For Lazy Developers |Ajax Data Controls Forum
Price
Member
75 Points
15 Posts
Re: SQL Server Error Returned
Mar 03, 2005 07:21 PM|LINK
Price
Member
75 Points
15 Posts
Re: SQL Server Error Returned
Mar 03, 2005 07:26 PM|LINK
Price
Member
75 Points
15 Posts
Re: SQL Server Error Returned
Mar 03, 2005 08:42 PM|LINK