Stack Overflow
Stack Overflow

Questions tagged [aspstate]

16 questions
5
votes
1 answer

ASP.NET - Different SessionId across servers when session is stored in SQL Server

I manage shared session state across 2 production web servers using SQL Server database. Recently I realized (And I am almost sure that this wasn't the case before) that the session is not really shared when jumping from server to server. Both…
Variant
  • 17,279
  • 4
  • 40
  • 65
3
votes
3 answers

Using ASP Session State DB on AWS RDS

I know this has been a topic that has been discussed in AWS forums before and SO How to setup sessionState with SQL Server mode on Amazon RDS As mentioned on the above thread and on a couple of stack overflow articles it would seem like there is a…
Jacob Polden
  • 73
  • 1
  • 8
2
votes
1 answer

ASP.NET SQLServer Session Performance vs. Local Variable

I am support a legacy application where I see code like this: 'Use Session for everything? If Session("UserType") = "Admin" Then 'do admin something ElseIf Session("UserType") = "Manager" Then 'do manager stuff ElseIf Session("UserType") =…
J Hays
  • 153
  • 9
2
votes
1 answer

Hung IIS requests RequestAcquireState

From time to time we are running into an issue where we have many requests with the following state in IIS: RequestAcquireState. We are using SqlSessionStateStore to manage sessions. When we have many requests in this state they eventually time out…
8adger
  • 67
  • 1
  • 2
  • 6
2
votes
0 answers

Unable to make the session state request to the session state server, and server is running

I'm getting the following error randomly, sometimes works, but sometimes it fails: Unable to make the session state request to the session state server. Please ensure that the ASP.NET State service is started and that the client and server…
Daniel Peñalba
  • 30,507
  • 32
  • 137
  • 219
1
vote
0 answers

ASPState database always empty ASP.NET MVC web app

We have an ASP.NET MVC webapp and not using anything like ASP.NET Identity. We'd like to store session (simple User ID string) in SQL Server for the sake of reliability over InProc (AND we also want to extend session timeout with SQL Server…
Dat Huynh
  • 11
  • 1
1
vote
1 answer

Deserialization of Session variables from ASPStateTempSessions database table

we have recently moved to session state 'SQL Server' in our Asp.net website. I can see sessions data with SessionItemShort as NULL and SessionItemLong column having data present in binary format as below. As per research, SessionItemLong data is…
IgnitedMind
  • 307
  • 5
  • 17
1
vote
0 answers

Connect to ASPState database from APP server instead of WEB server

We deploy our application in three tier model. UI on web server, Services on App server and database is on different server. From UI (web server) we dont allow database connections directly and it should go through our own services deployed on APP…
user1551655
  • 104
  • 9
1
vote
3 answers

Cannot open database "ASPState" requested by the login. The login failed. Login failed for user 'xxxx'

I am working on one project which is in Asp.Net web form and Sql server. When I run application I get the error Unable to connect Sql Server Session Database and inner exception is Cannot open database ASPState requested by the login. I did some…
Gayatri
  • 559
  • 2
  • 8
  • 16
1
vote
1 answer

ASPState database

I've a question that i can't seem to find the answer to anywhere, i have nine applications, eight of which run .NET 2.0 and have been running for 8 years. All of which uses an ASP state database. More recently I have a new site - running .NET 4.0.…
NewZeroRiot
  • 552
  • 1
  • 5
  • 22
1
vote
1 answer

Classic asp using ASPState

ASP.NET can save the session to database automatically. Is there any way to save the session to database in Classic ASP? I need to share the session between ASP.NET and Classic ASP by using the database. If Classic ASP isn't support this function.…
Roy Wong
  • 11
  • 1
0
votes
0 answers

How to specify custom name for ASPState database?

I am facing the problem that I need multiple ASPState databases for different ASP.NET projects on the same db server, beacuse I really want to share the Session State db for those projects. After doing some research (e.g. here and here), I created…
ˈvɔlə
  • 9,204
  • 10
  • 63
  • 89
0
votes
2 answers

Is it possible to clear the aspstate log in mssql

My ASPState.LDF file is more than 17GB now, and some of that data is quite old. Is there a way to delete all of the old data? Still learning SQL database management and I'm new to working with ASPState.
user3499114
  • 15
  • 1
  • 5
0
votes
1 answer

How can same application hosted on two different servers( environments) share the single ASPState database?

I have a asp.net mvc 2 application hosted on two different web servers (Staging and Demo servers).In both the servers the application is hosted as Default Web Site. Now for both the webservers we are using two different custom databases(StaginDB,…
santosh kumar patro
  • 7,231
  • 22
  • 71
  • 143
0
votes
1 answer

Using aspstate with .net 4.0 and .net 2.0

I have some legacy .net 2.0 websites sites set up on my dev machine. I have been been developing a 4.0 site which has been working fine. In both cases the same session db is used. If I access a 2.0 site it stops the 4.0 site from working giving this…
Tom Elmore
  • 1,980
  • 15
  • 20
1
2