Last post Oct 07, 2018 07:41 AM by ahmadk1992
Oct 04, 2018 12:20 PM|ahmadk1992|LINK
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.Web.HttpException: 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.
SO if anyone have faced this issue before and solved it please I need you to connect to my PC and ill give access to solve it because I have run into many links and websites about
solving this but nothing is working with me or I am maybe not understanding something right
Oct 04, 2018 01:25 PM|mudassarkhan|LINK
Oct 04, 2018 01:44 PM|ahmadk1992|LINK
Oct 05, 2018 02:19 AM|Fei Han - MSFT|LINK
Welcome to ASP.NET forums.
To narrow down the issue, please tell us what did you try and what didn't work. Besides,
this blog share the steps to troubleshoot and fix the issue, you can refer to it.
a few things which might cause it:
>Running both ASP.NET and classic ASP in the same application pool?
>Session tables are not added?
>Not have permission to access the database and stored procedures in ASPState database
Oct 07, 2018 05:21 AM|ahmadk1992|LINK
Hello Fei and thanks for your respond and well basically I have added the application pool and everything as I have seen on how to host your asp.net website through IIS and I did same steps as any youtube videos shows and my website does shows normally the
published one through IIS but the problem is when I click submit button the data doesn't actually updates to the database so please can you tell me how can I check if its running both asp.net and classic asp and well as well as I have tried to make a session
state in the tabs in the IIS but I kept getting an error when I start the website and I got a bit lost in terms of the steps to add aspstate database in my sql database so a big help with steps to solve these would be really appreciated since I went through
many links and videos but I haven't got it yet
Oct 07, 2018 07:17 AM|DA924|LINK
You are trying to make a state server using MS SQL Server for the IIS Web Server. You may want to post to the IIS forums as well.
Oct 07, 2018 07:41 AM|ahmadk1992|LINK