Stack Overflow
Stack Overflow

Questions tagged [sql-session-state]

41 questions
0
votes
1 answer

Changing ASP.NET InProc session state mode into State Server or SQL Server State

First, I am new to Web app programming. I come from Desktop apps (WinForms & WPF). Recently I have been assigned a project that was made in the past by ohter people. This project is done in ASP.NET MVC and it uses an InProc session state mode. Now,…
Willy
  • 9,848
  • 22
  • 141
  • 284
0
votes
1 answer

SQL Session State - Why does tempdb size grow out of control? How to prevent this?

We're currently using the tempdb to manage our SQL session state, but its size keeps growing out of control. Is there any way to manage or prevent this from happening? We are thinking of setting up a custom database to manage SQL state instead of…
Martyn
  • 1,446
  • 2
  • 19
  • 30
0
votes
1 answer

SSRS Report Viewer - ASP.Net Session Expired or not found on NLB (SQL Server)

Hi, I have an issue on NLB production environment where two application servers are configured. Both have a virtual directory of ReportViewer that renders SSRS reports in an iframe using an .aspx page. After the "ASP.NET session has expired or could…
zeppelin
  • 451
  • 1
  • 4
  • 24
0
votes
0 answers

How to share session between UI and Web Api?

I have two applications. One is the User interface, that stores information like UserID on the session. The other is a web api that communicate with the UI. I need to share this UI session with web api. 1- I know that is not recommended to use…
Ivo Queiroz
  • 21
  • 1
  • 8
0
votes
1 answer

ASP.NET SessionState SQL Server Issue

I am using Serialized Model objects of Entity Framework 6 to store in session. The session state is being stored in the database as per these settings:
Safi Ullah Bhatti
  • 137
  • 1
  • 12
0
votes
1 answer

SqlSessionState: Unable to cast object of type System.DBNull to type System.Byte[]

Occasionally we get the following error. I have not been able to reproduce it. I've tried logging out and navigating to a page that requires authentication, but it doesn't throw this exception. So far this exception has only occurred on web services…
Nate Hitze
  • 988
  • 1
  • 8
  • 18
0
votes
2 answers

Session not being persisted in ASPState database?

We have a webapp configured as a webgarden. Because of this we want to user store session state using sqlserver mode. My configuration in the web.config is as follows
Matt Stewart
  • 322
  • 3
  • 14
0
votes
1 answer

Can I override the session provider for a specific page?

Can I specify, say the InProc Session Provider for one page, and a database backed session provider for all other pages?
MatthewMartin
  • 32,326
  • 33
  • 105
  • 164
0
votes
1 answer

Links being rendered with strange path values

I've seen this a few times in our logs and users have also reported it to us but have never really gotten to the bottom of the problem. From time to time, a page will render from output caching with links that have a strange path value in. Say…
Dan Atkinson
  • 11,391
  • 14
  • 81
  • 114
0
votes
1 answer

Hide ASP.NET_SessionId Cookie

I wrote an ASP.Net MVC app that stores Session information in the database, but I can see the session id being stored in a browser cookie "ASP.NET_SessionId". Is this a security risk? Can the id be used to hack/steal a user's session?
user1513030
  • 67
  • 1
  • 6
0
votes
1 answer

How to get session length in minute in SQL Server

Using following query in my procedure I can count to connection to my database SELECT COUNT(dbid) as 'Total Connections' FROM master.dbo.sysprocesses WITH (nolock) WHERE dbid = 7 This is working fine, is there any way to get length…
user1544004
  • 207
  • 4
  • 9
1 2
3