Avatar of pvg1975
pvg1975
Flag for Argentina asked on

SQL Server session variables

Hi all,

Im configuring SQL Server session variables and Im getting the following error:

Server Error in '/' Application.
--------------------------------------------------------------------------------

Unable to use SQL Server because ASP.NET version 2.0 Session State is not installed on the SQL server. Please install ASP.NET Session State SQL Server version 2.0 or above.
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 ASP.NET version 2.0 Session State is not installed on the SQL server. Please install ASP.NET Session State SQL Server version 2.0 or above.

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.  


The funny thing is that I run the script for .NET V4, but it ask me for ASP.NET version 2.0 Session State.

Any thoughts?

Thanks!
ASP.NETMicrosoft SQL Server 2008

Avatar of undefined
Last Comment
Member_6283346

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Member_6283346

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
pvg1975

ASKER
Hi Ivan!

No, its 4.0, that's the first thing I checked out.
SOLUTION
Paul Jackson

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
pvg1975

ASKER
Hi Jacko!

Ok, there's a change, which is good... now I get this error:

Failed to login to session state SQL server for user 'IIS APPPOOL\ASP.NET v4.0'.

I just dont know how to identify the asp.net user in IIS7, I think the problem is there.
SOLUTION
Paul Jackson

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
pvg1975

ASKER
Hi Ivan and Jacko!

I wont use SQL Variables at the end, and I will split the point between you both.

Thanks for the help guys :)

Paula
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
pvg1975

ASKER
Jee... I did a wrong split, I wanted to split equaly, sorry about that :(
Member_6283346

Hi, Paula! I don't think I really helped you much on that, so don't worry about it )