Stack Overflow
Stack Overflow

Questions tagged [sql-session-state]

41 questions
1
vote
1 answer

SessionState in own SQL Server database on windows shared hosting

My ASP.NET site is on Windows Shared Hosting. I need to keep SessionState in SQL Server on my site, and standard way is to use ASPState DB. But that DB is inaccessible on windows shared hosting, and support said that unfortunately they can't provide…
ihorko
  • 6,855
  • 25
  • 77
  • 116
1
vote
0 answers

Duplicate references in ASP.NET SQL session state

I run an ASP.NET web application and have only just noticed that the behaviour of duplicate references in session state differs between InProc and ASP.NET SQL session state. With InProc, duplicate references seem to stay reference equal over…
Rawling
  • 49,248
  • 7
  • 89
  • 127
1
vote
1 answer

How to get AdGroupAuthProvider worked with OrmLiteCacheClient?

I want that application will be accessible for end user regardless on which server node LoadBalancer redirects. So, I would like to use OrmLiteCacheClient to store session in MSSQL DB. I have the following code (there is only part of…
essential
  • 648
  • 1
  • 7
  • 19
1
vote
1 answer

Is it possible to share SQL Server database for storing session state in Asp.Net Web Forms

I have an Asp.Net web forms application that uses the session state stored in SQL Server. I have created this session state database following this article - execute the script InstallSqlState.sql located in system…
Jenan
  • 3,408
  • 13
  • 62
  • 105
1
vote
1 answer

Is it posible to use SQL Server Session Context with Azure elastic queries

I want to know if it's posible to share SQL Server SESSION CONTEXT variables between different Azure Sql databases using Elastic Queries. I searched in official documentation but i can't found any information about this feature is available or not.
Pablo García
  • 359
  • 3
  • 9
1
vote
0 answers

Unable to serialize the session state. In 'StateServer' and 'SQLServer' mode while using Itextsharp 5.5.1.0

I Got below error while using session state SQL server with itextsharpt dll version 5.5.1.0. I am using asp.net 4.0 web application. Unable to serialize the session state. In 'StateServer' and 'SQLServer' mode, ASP.NET will serialize the session…
Sam Peter
  • 71
  • 1
  • 9
1
vote
2 answers

How to move the session state from InProc to SQLServer

I am currently using InProc session state mode in my .net web project. I want move that from InProc to SQLServer session state as I am going to use a load balancer. What are the steps that I need to follow? In my C# code, I use as sessions as…
Dumi
  • 1,414
  • 4
  • 21
  • 41
1
vote
0 answers

What is the recommended approach to implement SQL session state since ASP.NET Identity was released?

These are the options I am aware of: ASP.NET Universal…
Brendon
  • 111
  • 7
1
vote
1 answer

How to get the session details in servicestack application from SQLServer using session id sent from mvc application?

I have two applications deployed on different servers. 1) ASP.net MVC 4 web application with sessionState mode="SQLServer" for session management 2) Servicestack service application with sessionState mode="SQLServer" for session management ( yes i…
A_m0
  • 974
  • 2
  • 17
  • 45
1
vote
1 answer

SQL Server Session for an Asp.Net MVC application

Isn't SQL Server sessioning for an ASP.NET MVC application fundamentally the same as ASP.NET? If so, do you guys traditionally impersonate your front end user for the sessioning database or setup a static SQL Server user? Just trying to setup our…
RailRhoad
  • 2,128
  • 2
  • 25
  • 39
1
vote
3 answers

SQLServer SessionState

I am using InProc mode of SessionState, but my app is keep restarting because of the recycling of application pool so I am loosing session of currently logged in users. I want to change to save it in database. I edited my webconfig like…
zdarsky.peter
  • 6,188
  • 9
  • 39
  • 60
0
votes
1 answer

How does SQL Server session state persistence work?

I'm not a fan of using ASP.NET session state, but our application is using it at this time. We are using SQL Server mode for session state persistence. I'm considering caching authorization check results in the session state, but I worry about the…
Jacob
  • 77,566
  • 24
  • 149
  • 228
0
votes
0 answers

Is it possible to store extra data in session store on DB ASP.NET?

Is there a way to store extra data in the SessionStorage tables generated by the SQL Server session provider in an ASP.NET Core 3 MVC Web application? For example in the ASPStateTempSessions table, add the username, IP address and browser from which…
SGP
  • 358
  • 2
  • 18
0
votes
1 answer

Various difficulties creating ASP.NET Session tables via aspnet_regsql.exe

We're trying to move ASP.NET session state for one of our Azure web apps into a database, and it seems like the aspnet_regsql.exe tool is the way to go. Unfortunately, I'm getting stuck on a few issues below. It's an Azure SQL database, and I'm…
Matt Wanchap
  • 841
  • 8
  • 20
0
votes
1 answer

Share session across subdomains with multiple domains

I have 2 Asp.Net Core 2.2 applications and I want to share session between them. I've set up session in a SQL database and both connect ok. They are on different sub domains. I understand that I can set the Cookie.Domain the startup file, which…
David Hendrick
  • 93
  • 2
  • 13
1
2
3