Stack Overflow
Stack Overflow

Questions tagged [sql-session-state]

41 questions
19
votes
3 answers

Losing Session State with ASP.NET/SQL Server

I have a ASP.NET MVC workflow configured as two websites managed by a load balancer. The websites use Sql Server as the session state provider and have authentication switch off (its not required). Now, sporadically I appear to be losing session…
Matthew Abbott
  • 60,571
  • 9
  • 104
  • 129
13
votes
4 answers

Invalid object name 'ASPState.dbo.ASPStateTempApplications' - Exception after renaming the ASPState Database

I have created new session database using the command (aspnet_regsql.exe -S -E -ssadd -sstype p) and it created DB called ASPState. Then I renamed it to something like E_ASPStateDB. I have configured the correct DB name in the sessionState…
Ravi
  • 1,293
  • 6
  • 20
  • 31
9
votes
3 answers

How to share Session in ASP.NET Core 3 between 2 servers?

How does one share session in ASP.NET Core 3 between 2 servers (load balanced)? And can session be shared between several web services/APIs and the main ASP.NET MVC app? I am very new to .NET Core 3, I was used to working with session state in…
SGP
  • 358
  • 2
  • 18
6
votes
1 answer

SQL Server Session State, web farm, and IIS configuration

So I set up SQL Server Session State using SQL Server 2008 and the temp database and today I decided to look into the data in the tables only to find this in the ASPStateTempApplications table: AppId AppName 538231025 …
Jonas Stawski
  • 6,682
  • 6
  • 61
  • 106
5
votes
2 answers

Sharing ASP.NET State databases between multiple apps

Is it better for a collection of ASP.NET web apps to share the same session database, or should each one have its own? If there is no significant difference, having a single database would be preferable due to easier maintenance. Background My team…
MikeWyatt
  • 7,842
  • 10
  • 50
  • 71
4
votes
1 answer

ASP.NET SessionState with allowCustomSqlDatabase="true" doesn't call specified database

The Microsoft documentation here http://msdn.microsoft.com/en-us/library/h6bb9cz9(v=vs.90).aspx and several SO articles indicate that specifying allowCustomSqlDatabase="true" in the sessionState declaration of an ASP.NET web.config file will allow…
Jonathan Hensley
  • 131
  • 1
  • 1
  • 7
4
votes
3 answers

ASP.NET SQL Server Session State extremely slow

I'm having problems with an ASP.NET application that I need to web-farm, however just logging into my application takes at about 15 seconds I did a little experiment where I created a non-web farmed version of my application and then used INPROC…
WhiskerBiscuit
  • 4,795
  • 8
  • 62
  • 100
3
votes
1 answer

how to check session value(exist for user) in ASPState database using sql server session management

We had implemented web farms with SQL server session management for my asp.net applications. Some time this implementation is not working fine. I want to know how can i check session value(exist for user) in ASPState database because i was suspected…
Pankaj
  • 4,419
  • 16
  • 50
  • 72
3
votes
1 answer

Configuring SessionState with remote configSource file

In my web.config I have: In SessionState.config I have:
rboarman
  • 8,248
  • 8
  • 57
  • 87
3
votes
1 answer

Session Variables Is Null after Redirecting to a New Page

MVS 2012 SQL Server 2008 R2 I have an object that is being store in a session using a session wrapper. During login, I initialize the object and set the session appropriately. After authenticating the user, I redirect the user to the user index…
Josiane Ferice
  • 921
  • 5
  • 15
  • 31
3
votes
3 answers

Switching Sql Session State databases

I have one instance of web application connected to multiple databases. Based on the domain name (for example www.shop1.com, www.shop2.com, ..) I switch the connection string in the Entity Framework. shop1.com -> Database1 shop2.com ->…
Oxon
  • 4,901
  • 8
  • 40
  • 54
3
votes
1 answer

Does ASP.NET transfer ALL session data from SQL server at the start of a request, or only as needed?

I'm using ASP.NET, with session state stored out of process in SQL Server. When a page request begins, are the entire contents of a user's session retrieved from the DB, deserialized, and sent to the ASP.NET process in one fell swoop, or are…
Seth Petry-Johnson
  • 11,845
  • 7
  • 49
  • 69
2
votes
2 answers

Implementing custom session state provider in ASP.NET MVC

I'm working on implementing a custom session state provider for my ASP.NET MVC application. My requirement is I've to store the session data as xml in a custom table in Sql server. Can I use the existing sql session state provider (overriding some…
VJAI
  • 32,167
  • 23
  • 102
  • 164
2
votes
0 answers

Share session between multiple applications using .net core

We are using SQL Session state to persist data in legacy application and access in future application application. If anyone has idea how to share the SQL session state between multiple sites using .net core then please share the info. Step 1: We…
Harish
  • 21
  • 2
2
votes
1 answer

Web Host has strange settings, need alternative session state suggestions

I am building a web site for a sports club. The club is not interested in moving their hosting to a different web host, so I'm stuck with the current host. I deployed the new web application to the host, but after a few hours of testing it became…
Ron Penton
  • 1,511
  • 1
  • 12
  • 24
1
2 3