473,322 Members | 1,562 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,322 software developers and data experts.

How to configure SQL Server Session State

Can anyone please guide me how to configure SQL Server session state. I have configured upto an extent, but it is giving error.
--
Christopher
Nov 18 '05 #1
5 1389
Hi Christopher:

Can you tell us the error message?

--
Scott
http://www.OdeToCode.com

On Tue, 6 Jul 2004 20:56:01 -0700, "Christopher"
<Ch*********@discussions.microsoft.com> wrote:
Can anyone please guide me how to configure SQL Server session state. I have configured upto an extent, but it is giving error.


Nov 18 '05 #2
Error Message is:
Unable to find the data source/Data Source doesnot Exist.
But my data source is available and exist properly.
--
Christopher
"Scott Allen" wrote:
Hi Christopher:

Can you tell us the error message?

--
Scott
http://www.OdeToCode.com

On Tue, 6 Jul 2004 20:56:01 -0700, "Christopher"
<Ch*********@discussions.microsoft.com> wrote:
Can anyone please guide me how to configure SQL Server session state. I have configured upto an extent, but it is giving error.


Nov 18 '05 #3
Hmm. Really there are only two steps:

1) Run one of the SQL state .sql scripts from
systemroot\Microsoft.NET\Framework\versionNumber.

2) Set the sessionState element in web.config to mode="SQLServer" and
the correct sqlConnectionString.

If you have trouble finding the data source, I'd double check the
connection string in 2. Also check to see if the user has permissions
to access the state database.

--s

On Wed, 7 Jul 2004 03:44:01 -0700, "Christopher"
<Ch*********@discussions.microsoft.com> wrote:
Error Message is:
Unable to find the data source/Data Source doesnot Exist.
But my data source is available and exist properly.


--
Scott
http://www.OdeToCode.com
Nov 18 '05 #4
Dear Allen,
Thanks for your tips.
But the problem is not solved yet. I am unable to identify where is the problem. In my computer only one ASP.NET application is running and session state in SQL Server is maintained successfully. In my deployment machine, there are 7 ASP.NET applications are running. There, the problem arises...
--
Christopher
"Scott Allen" wrote:
Hmm. Really there are only two steps:

1) Run one of the SQL state .sql scripts from
systemroot\Microsoft.NET\Framework\versionNumber.

2) Set the sessionState element in web.config to mode="SQLServer" and
the correct sqlConnectionString.

If you have trouble finding the data source, I'd double check the
connection string in 2. Also check to see if the user has permissions
to access the state database.

--s

On Wed, 7 Jul 2004 03:44:01 -0700, "Christopher"
<Ch*********@discussions.microsoft.com> wrote:
Error Message is:
Unable to find the data source/Data Source doesnot Exist.
But my data source is available and exist properly.


--
Scott
http://www.OdeToCode.com

Nov 18 '05 #5
Hi
Here's a Microsoft KB link.

Using one SQL database for all applications for SQL Server session state may cause a bottleneck.
http://support.microsoft.com/default...b;en-us;820782

Verify your web.config file...
<----CODE STARTS-------------->
<sessionState
mode="SQLServer"
allowCustomSqlDatabase="true" <!--This line is a new attribute to sessionState. -->
sqlConnectionString="data source=127.0.0.1;database=mydatabase;user id=<username>;password=<strong password>"
cookieless="false"
timeout="20"
/>
<---CODE ENDS--------------->

--
Thanks & Regards,
John Paul. A
MCP
"Christopher" wrote:
Dear Allen,
Thanks for your tips.
But the problem is not solved yet. I am unable to identify where is the problem. In my computer only one ASP.NET application is running and session state in SQL Server is maintained successfully. In my deployment machine, there are 7 ASP.NET applications are running. There, the problem arises...
--
Christopher
"Scott Allen" wrote:
Hmm. Really there are only two steps:

1) Run one of the SQL state .sql scripts from
systemroot\Microsoft.NET\Framework\versionNumber.

2) Set the sessionState element in web.config to mode="SQLServer" and
the correct sqlConnectionString.

If you have trouble finding the data source, I'd double check the
connection string in 2. Also check to see if the user has permissions
to access the state database.

--s

On Wed, 7 Jul 2004 03:44:01 -0700, "Christopher"
<Ch*********@discussions.microsoft.com> wrote:
Error Message is:
Unable to find the data source/Data Source doesnot Exist.
But my data source is available and exist properly.


--
Scott
http://www.OdeToCode.com

Nov 18 '05 #6

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

Similar topics

5
by: Phil Grimpo | last post by:
I have a very odd situation here. I have an administration page, where based on a users permissions, a recordset is called from the SQL server which has a list of paths to "Module Menus". Each of...
4
by: Phil Grimpo | last post by:
I had previously explained this problem in a different thread, but now that I have an IISState log, I figured I'd re-start the thred. My situation and the log are following... I have a very odd...
7
by: Sidd | last post by:
Hi, I tried finding and example of multithreaded client-serve program in python. Can any one please tell me how to write a multithreaded client-server programn in python such that 1.It can handle...
2
by: James Wallace | last post by:
I hope that someone can help me out there with this problem. I get an itermittant problem with our web page that occurs about once every 10 to 15 days where the only way to fix the problem is to...
10
by: tshad | last post by:
I have been using the default session state (InProc) and have found that I have been loosing my information after a period of time (normally 20 minutes). Is there anyway to find out how much...
0
by: Maciek | last post by:
Hi When I set Session state mode to StateServer (IIS 6.0; windows2003; .NET 2.0) in my application, I have recived this message:...
13
by: José Joye | last post by:
Hello, What is the best way to stop a remoting server (Singleton SAO) that has been started with RemotingConfiguration.Configure(). For sure, I want to do this without quitting the application...
1
by: MG | last post by:
can any one please guide me about storing session cookies using a state server. and if client has cookies turned off then will the state server store the session cookies. excuse me , if i am too...
13
by: Eric Layman | last post by:
Hi everyone, Will clustering of webservers affect SESSION states? Is there a dotnet term for the above mentioned scenario? Pls advise. Thanks.
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.