hi
I use sessionState in website to save session in sql server
<sessionState mode="SQLServer" allowCustomSqlDatabase="true" timeout="1440" sqlConnectionString="Data Source=.;Initial Catalog=3140ASPState;User ID=3140ASPState.ir;Password=1160806*n" />
but when I upload site below error happen:
Unable to use SQL Server because either ASP.NET version 2.0 Session State is not installed on the SQL server, or ASP.NET does not have permission to run the dbo.TempGetVersion stored procedure. If the ASP.NET Session State schema has not been installed, please install ASP.NET Session State SQL Server version 2.0 or above. If the schema has been installed, please grant execute permission on the dbo.TempGetVersion stored procedure to either the ASP.NET application pool identity, or the Sql Server user specified in the sqlConnectionString attribute.
I called to server company and they told that do every things that show in above error and they told me that I have problem in webconfig and I should change something but I don't know what should I do for solving this problem
best regards
neda