Permission error

i have my sql server database set up but when i try to run my app i get this error:

http://img308.imageshack.us/img308/2862/untitledep4.png

any help you be grateful :)might be helpful if we could see the pics there |||

It's a permission issue. You need to grant EXECUTE permission for the 'TempGetStateItemExclusive2' object to the mapping user of the account in ASPState database. You can either do this in Management Studio->Databases->ASPState->Programmability->Stored Procedures or Functions->TempGetStateItemExclusive2->Properties->switch to Permissions tab->add EXECUTE permission for the user; or issue such command :

GRANT EXECUTE on ASPState.dbo.TempGetStateItemExclusive2 to xxx

|||

Iori_Jay:

It's a permission issue. You need to grant EXECUTE permission for the 'TempGetStateItemExclusive2' object to the mapping user of the account in ASPState database. You can either do this inManagement Studio->Databases->ASPState->Programmability->Stored Procedures or Functions->TempGetStateItemExclusive2->Properties->switch to Permissions tab->add EXECUTE permission for the user; or issue such command :

GRANT EXECUTE on ASPState.dbo.TempGetStateItemExclusive2 to xxx

do u mean doing thisnin visual studio or sql server? where do i find the management studio?|||

Management Studio is a tool for SQL Server, and the express edition can be downloaded from here:

http://msdn.microsoft.com/vstudio/express/sql/download/