After i published my website i get this error

Question

User121898581 posted

Server Error in '/' Application.

---

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.

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.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

Answer 1

User-1171043462 posted

Refer

https://stackoverflow.com/questions/15380423/asp-net-session-state-mode-sqlserver

Answer 2

User121898581 posted
I have been there didn't work anything for me

Answer 3

User61956409 posted

Hi ahmadk1992,

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

With Regards,

Fei Han

Answer 4

User121898581 posted

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

Answer 5

User1120430333 posted

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.

https://forums.iis.net/

Answer 6

User121898581 posted
Okay