473,409 Members | 2,056 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,409 software developers and data experts.

SQL Server/ASP.NET Session State Management

I was able to configure and run an ASP.NET (V2 framework) application to use
state session data stored on a SQL Server 2000 server database per MS KB
311209 (Persistent SQL Server Session State Management) without issues.

In the application "web.config" file I'm using this for the connection
string:
<sessionState mode="SQLServer" sqlConnectionString="Integrated
Security=SSPI;data source=sqlserver\instancename" />.

With this string the connection is established to the "ASPState" db in the
context of the web server "identity" (a user in SQL with dbo database
rights) so I don't have to specify a username or password as part of the
connection string.

However, I see that by default the SQL script "InstallPersistSqlState.sql"
sets up the "ASPState" database as accessible to all web applications that
utilize the above connection string.

Is there a way to somehow restrict the ASPState db, a store procedure,
etc... (or perhaps modify the sql scripts) so that only a specific
application can access this db for storing the ASP session data instead of
being globally accessible?
Jul 28 '06 #1
0 886

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Abhilash.k.m | last post by:
This is regarding the session management using Out of proc session management(SQL SERVER). Among the samples below which one is better to set the session? 1. There are 20 session...
6
by: Steven Spits | last post by:
Hi, We're thinking of moving session from inproc to a state server. My question is: should we expect a difference in performance? Is it noticeable? Steven - - -
2
by: jamezw | last post by:
Hello I work on a website where we have 3 servers running one site so we use the SQLServer option for state management. We are using the persistent ASPState database. All 3 of our webservers are...
0
by: Shell | last post by:
Hi All, We have an application that uses SQL Server 2000 for State Management data. We previously use to build and deploy this application using ASP.NET Beta 2 version. Now we are using ASP.NET...
2
by: Jobs | last post by:
Download the JAVA , .NET and SQL Server interview with answers Download the JAVA , .NET and SQL Server interview sheet and rate yourself. This will help you judge yourself are you really worth of...
2
by: JoeSep | last post by:
Hi! Is it correct/safe to define a connection pool in the string "sqlConnectionString" of the "sessionState" section of Web.config? - The application is developed using AspNet 1.1 in a Windows...
18
by: BillE | last post by:
When a user opens a new IE browser window using File-New-Window the integrity of an application which relies on session state is COMPLETELY undermined. Anyone who overlooks the fact that...
4
by: Smokey Grindle | last post by:
What are the advantages of using ASP.NET's session state server service over using InProc state sessions? Also if you have a state server service running, is there any way to find out when a...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.