SQLServer session state

Hi,

does anybody know how (if possible) to change the database name for the
session database (which is ASPState)?

My problem is that our website/sqlserverdb is hosted by an isp, and we are
not alone (on the server)

Regards,

Agge

Nov 18 '05 #1

Subscribe Post Reply

1331

Jim Cheshire [MSFT]

Agge,

Yes, it's possible. See this article:

820782 Select a Database Name When You Use a SQL Server Session State in
ASP.NET
http://support.microsoft.com/?id=820782

You will have to call us for the fix. The number is (800) 936-5800.

Jim Cheshire, MCSE, MCSD [MSFT]
Developer Support
ASP.NET
ja******@online.microsoft.com

This post is provided as-is with no warranties and confers no rights.

--------------------

From: "A" <ne**@agge.dk>
Subject: SQLServer session state
Date: Wed, 19 Nov 2003 09:51:42 +0100
Lines: 13
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <Oq**************@TK2MSFTNGP10.phx.gbl>
Newsgroups: microsoft.public.dotnet.framework.aspnet
NNTP-Posting-Host: cpe.atm2-0-1061199.0x50a63bf2.bynxx13.customer.tele.dk 80.166.59.242Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP10.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.aspnet:191918
X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet

Hi,

does anybody know how (if possible) to change the database name for the
session database (which is ASPState)?

My problem is that our website/sqlserverdb is hosted by an isp, and we are
not alone (on the server)

Regards,

Agge

Nov 18 '05 #2

Thanks,

I've just called my local ms office to get the fix...

The KB article states the problem only under .net 1.0?
Should i have been resolved?

I'am running .net 1.1 (vs.net 2003) on my client machine (XP - local
webserver), but i cant get it working (without fix).

Agge

"Jim Cheshire [MSFT]" <ja******@online.microsoft.com> skrev i en meddelelse
news:G$**************@cpmsftngxa07.phx.gbl...

Agge,

Yes, it's possible. See this article:

820782 Select a Database Name When You Use a SQL Server Session State in
ASP.NET
http://support.microsoft.com/?id=820782

You will have to call us for the fix. The number is (800) 936-5800.

Jim Cheshire, MCSE, MCSD [MSFT]
Developer Support
ASP.NET
ja******@online.microsoft.com

This post is provided as-is with no warranties and confers no rights.

--------------------
From: "A" <ne**@agge.dk>
Subject: SQLServer session state
Date: Wed, 19 Nov 2003 09:51:42 +0100
Lines: 13
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <Oq**************@TK2MSFTNGP10.phx.gbl>
Newsgroups: microsoft.public.dotnet.framework.aspnet
NNTP-Posting-Host: cpe.atm2-0-1061199.0x50a63bf2.bynxx13.customer.tele.dk

80.166.59.242
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP10.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.aspnet:191918X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet

Hi,

does anybody know how (if possible) to change the database name for the
session database (which is ASPState)?

My problem is that our website/sqlserverdb is hosted by an isp, and we arenot alone (on the server)

Regards,

Agge

Nov 18 '05 #3

Jim Cheshire [MSFT]

Agge,

The fix is only for 1.0. It looks like we have a fix for 1.1, but we
haven't packaged it yet. I have pinged the dev to see about getting it
packaged.

If you can send me an e-mail (leave off the "online"), I will respond to
you privately with status.

Jim Cheshire, MCSE, MCSD [MSFT]
Developer Support
ASP.NET
ja******@online.microsoft.com

This post is provided as-is with no warranties and confers no rights.
--------------------

From: "A" <ne**@agge.dk>
References: <Oq**************@TK2MSFTNGP10.phx.gbl> <G$**************@cpmsftngxa07.phx.gbl>Subject: Re: SQLServer session state
Date: Thu, 20 Nov 2003 09:57:48 +0100
Lines: 69
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <eK**************@tk2msftngp13.phx.gbl>
Newsgroups: microsoft.public.dotnet.framework.aspnet
NNTP-Posting-Host: cpe.atm2-0-1061199.0x50a63bf2.bynxx13.customer.tele.dk 80.166.59.242Path: cpmsftngxa07.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTN GXA05.phx.gbl!TK2MSFTNGP08
.phx.gbl!tk2msftngp13.phx.gblXref: cpmsftngxa07.phx.gbl microsoft.public.dotnet.framework.aspnet:191489
X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet

Thanks,

I've just called my local ms office to get the fix...

The KB article states the problem only under .net 1.0?
Should i have been resolved?

I'am running .net 1.1 (vs.net 2003) on my client machine (XP - local
webserver), but i cant get it working (without fix).

Agge

"Jim Cheshire [MSFT]" <ja******@online.microsoft.com> skrev i en meddelelse
news:G$**************@cpmsftngxa07.phx.gbl...
Agge,

Yes, it's possible. See this article:

820782 Select a Database Name When You Use a SQL Server Session State in
ASP.NET
http://support.microsoft.com/?id=820782

You will have to call us for the fix. The number is (800) 936-5800.

Jim Cheshire, MCSE, MCSD [MSFT]
Developer Support
ASP.NET
ja******@online.microsoft.com

This post is provided as-is with no warranties and confers no rights.

--------------------
>From: "A" <ne**@agge.dk>
>Subject: SQLServer session state
>Date: Wed, 19 Nov 2003 09:51:42 +0100
>Lines: 13
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
>Message-ID: <Oq**************@TK2MSFTNGP10.phx.gbl>
>Newsgroups: microsoft.public.dotnet.framework.aspnet
>NNTP-Posting-Host:
cpe.atm2-0-1061199.0x50a63bf2.bynxx13.customer.tele.dk
80.166.59.242
>Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP10.phx.gbl
>Xref: cpmsftngxa06.phx.gbl

microsoft.public.dotnet.framework.aspnet:191918 >X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
>
>Hi,
>
>does anybody know how (if possible) to change the database name for the
>session database (which is ASPState)?
>
>My problem is that our website/sqlserverdb is hosted by an isp, and weare >not alone (on the server)
>
>Regards,
>
>Agge
>
>
>

Nov 18 '05 #4

I tried to install the fix on my own machine, but it failed (XP .net 1.1)
I then tried to install on a old server (win2k .net 1.0), it worked fine...
But i want to be able to test on my own machine (support for
allowCustomSqlDatabase attibute in web.config)

If any body has an idea or knows how to "hack" it, please write back

Agge
"Jim Cheshire [MSFT]" <ja******@online.microsoft.com> skrev i en meddelelse
news:G$**************@cpmsftngxa07.phx.gbl...

Agge,

Yes, it's possible. See this article:

820782 Select a Database Name When You Use a SQL Server Session State in
ASP.NET
http://support.microsoft.com/?id=820782

You will have to call us for the fix. The number is (800) 936-5800.

Jim Cheshire, MCSE, MCSD [MSFT]
Developer Support
ASP.NET
ja******@online.microsoft.com

This post is provided as-is with no warranties and confers no rights.

--------------------
From: "A" <ne**@agge.dk>
Subject: SQLServer session state
Date: Wed, 19 Nov 2003 09:51:42 +0100
Lines: 13
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <Oq**************@TK2MSFTNGP10.phx.gbl>
Newsgroups: microsoft.public.dotnet.framework.aspnet
NNTP-Posting-Host: cpe.atm2-0-1061199.0x50a63bf2.bynxx13.customer.tele.dk

80.166.59.242
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP10.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.aspnet:191918X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet

Hi,

does anybody know how (if possible) to change the database name for the
session database (which is ASPState)?

My problem is that our website/sqlserverdb is hosted by an isp, and we arenot alone (on the server)

Regards,

Agge

Nov 18 '05 #5

Jim Cheshire [MSFT]

Agge,

You can't hack it. This is a fix in the binaries for ASP.NET.

Because I anticipated that you might be running 1.1, I talked to the dev
who wrote this fix and asked her about packaging this for 1.1. We have the
fix, but we just need to package it.

What you'll need to do is call us and open a case. We can provide you with
the hotfix.

Thanks.

Jim Cheshire, MCSE, MCSD [MSFT]
Developer Support
ASP.NET
ja******@online.microsoft.com

This post is provided as-is with no warranties and confers no rights.

--------------------

From: "A" <ne**@agge.dk>
References: <Oq**************@TK2MSFTNGP10.phx.gbl> <G$**************@cpmsftngxa07.phx.gbl>Subject: Re: SQLServer session state
Date: Wed, 26 Nov 2003 15:13:17 +0100
Lines: 65
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <ub**************@TK2MSFTNGP11.phx.gbl>
Newsgroups: microsoft.public.dotnet.framework.aspnet
NNTP-Posting-Host: cpe.atm2-0-1061199.0x50a63bf2.bynxx13.customer.tele.dk 80.166.59.242Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA06.phx.gbl!TK2MSFT NGXA05.phx.gbl!TK2MSFTNGP0
8.phx.gbl!TK2MSFTNGP11.phx.gblXref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.aspnet:193485
X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet

I tried to install the fix on my own machine, but it failed (XP .net 1.1)
I then tried to install on a old server (win2k .net 1.0), it worked fine...
But i want to be able to test on my own machine (support for
allowCustomSqlDatabase attibute in web.config)

If any body has an idea or knows how to "hack" it, please write back

Agge
"Jim Cheshire [MSFT]" <ja******@online.microsoft.com> skrev i en meddelelse
news:G$**************@cpmsftngxa07.phx.gbl...
Agge,

Yes, it's possible. See this article:

820782 Select a Database Name When You Use a SQL Server Session State in
ASP.NET
http://support.microsoft.com/?id=820782

You will have to call us for the fix. The number is (800) 936-5800.

Jim Cheshire, MCSE, MCSD [MSFT]
Developer Support
ASP.NET
ja******@online.microsoft.com

This post is provided as-is with no warranties and confers no rights.

--------------------
>From: "A" <ne**@agge.dk>
>Subject: SQLServer session state
>Date: Wed, 19 Nov 2003 09:51:42 +0100
>Lines: 13
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
>Message-ID: <Oq**************@TK2MSFTNGP10.phx.gbl>
>Newsgroups: microsoft.public.dotnet.framework.aspnet
>NNTP-Posting-Host:
cpe.atm2-0-1061199.0x50a63bf2.bynxx13.customer.tele.dk
80.166.59.242
>Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP10.phx.gbl
>Xref: cpmsftngxa06.phx.gbl

microsoft.public.dotnet.framework.aspnet:191918 >X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
>
>Hi,
>
>does anybody know how (if possible) to change the database name for the
>session database (which is ASPState)?
>
>My problem is that our website/sqlserverdb is hosted by an isp, and weare >not alone (on the server)
>
>Regards,
>
>Agge
>
>
>

Nov 18 '05 #6

Hi Jim,

I talked to my local ms office and they would "look in to it", i'll send
them your reply (then they will know what to do).

Thanx alot...

Agge
"Jim Cheshire [MSFT]" <ja******@online.microsoft.com> skrev i en meddelelse
news:ES**************@cpmsftngxa06.phx.gbl...

Agge,

You can't hack it. This is a fix in the binaries for ASP.NET.

Because I anticipated that you might be running 1.1, I talked to the dev
who wrote this fix and asked her about packaging this for 1.1. We have the fix, but we just need to package it.

What you'll need to do is call us and open a case. We can provide you with the hotfix.

Thanks.

Jim Cheshire, MCSE, MCSD [MSFT]
Developer Support
ASP.NET
ja******@online.microsoft.com

This post is provided as-is with no warranties and confers no rights.

--------------------
From: "A" <ne**@agge.dk>
References: <Oq**************@TK2MSFTNGP10.phx.gbl> <G$**************@cpmsftngxa07.phx.gbl>
Subject: Re: SQLServer session state
Date: Wed, 26 Nov 2003 15:13:17 +0100
Lines: 65
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <ub**************@TK2MSFTNGP11.phx.gbl>
Newsgroups: microsoft.public.dotnet.framework.aspnet
NNTP-Posting-Host: cpe.atm2-0-1061199.0x50a63bf2.bynxx13.customer.tele.dk

80.166.59.242
Path:

cpmsftngxa06.phx.gbl!TK2MSFTNGXA06.phx.gbl!TK2MSFT NGXA05.phx.gbl!TK2MSFTNGP0 8.phx.gbl!TK2MSFTNGP11.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.aspnet:193485
X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet

I tried to install the fix on my own machine, but it failed (XP .net 1.1)
I then tried to install on a old server (win2k .net 1.0), it worked fine...But i want to be able to test on my own machine (support for
allowCustomSqlDatabase attibute in web.config)

If any body has an idea or knows how to "hack" it, please write back

Agge
"Jim Cheshire [MSFT]" <ja******@online.microsoft.com> skrev i en meddelelsenews:G$**************@cpmsftngxa07.phx.gbl...
Agge,

Yes, it's possible. See this article:

820782 Select a Database Name When You Use a SQL Server Session State in ASP.NET
http://support.microsoft.com/?id=820782

You will have to call us for the fix. The number is (800) 936-5800.

Jim Cheshire, MCSE, MCSD [MSFT]
Developer Support
ASP.NET
ja******@online.microsoft.com

This post is provided as-is with no warranties and confers no rights.

--------------------
>From: "A" <ne**@agge.dk>
>Subject: SQLServer session state
>Date: Wed, 19 Nov 2003 09:51:42 +0100
>Lines: 13
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
>Message-ID: <Oq**************@TK2MSFTNGP10.phx.gbl>
>Newsgroups: microsoft.public.dotnet.framework.aspnet
>NNTP-Posting-Host:

cpe.atm2-0-1061199.0x50a63bf2.bynxx13.customer.tele.dk 80.166.59.242
>Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP10.phx.gbl
>Xref: cpmsftngxa06.phx.gbl

microsoft.public.dotnet.framework.aspnet:191918
>X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
>
>Hi,
>
>does anybody know how (if possible) to change the database name for the >session database (which is ASPState)?
>
>My problem is that our website/sqlserverdb is hosted by an isp, and we

are
>not alone (on the server)
>
>Regards,
>
>Agge
>
>
>

Nov 18 '05 #7

Similar topics

session state - SqlServer

by: quique | last post by:

Hi all, I want to know the advantages and disadvantages of the methods of maintain session state, obviously if i choose sqlserver is the most robust but the less performace.. If wan't to...

ASP.NET

SQLServer session state performance issues

by: John Q. Smith | last post by:

I'm trying to find out some of the details behind OOP state management with SQL Server. For instance - how long does the session object live on any server? Is it created and destoyed with each...

ASP.NET

SQLServer Session State

by: Julie Barnet | last post by:

Hi, I am having a problem with my session state through sql server. This used to work, then all of a sudden (the only change was setting up replication in the sqlserver database) it stopped...

ASP.NET

Session_End and SqlServer Session Mode

by: karahan celikel | last post by:

I realized that when SqlServer mode is used for session management Session_End event is not fired in global.asax. What can I do if I want to do something when a user's session end? Thanks

ASP.NET

SessionID and SQLServer Session State

by: Jeff Carver | last post by:

I've been experimenting with SQLServer session state, and I'm puzzled by something. When I use Session.SessionID to display the session ID, I get a 24-character string, e.g.: ...

ASP.NET

Using SQLServer Session State without connection string in web.config

by: Chris Snyder | last post by:

Hello all. I have a problem that is probably failry easy to solve, but I don't know where to look. (Or, really, what to look for.) My customer has a tool (written in .NET) that encrypts strings....

ASP.NET

APIs for SQLServer state storage

by: Kishore Gopalan | last post by:

Hi, Is there a set of APIs that would let me access the tables where ASP.NET stores the state when in SQLServer mode. Thanks. Kishore

ASP.NET

Session State works for InProc, but not for SQLServer mode

by: Jamie Schatte | last post by:

We have two ASP.NET 2.0 websites, both running on the same production web server. One website uses SQLServer mode for session state with no problems. However, although the other website works great...

ASP.NET

session expiry when using sessionState mode="SQLServer"

by: Moe Sisko | last post by:

Using dotnet 2.0 sp1, I've got ASP.NET session state working ok in SQLServer mode, but the sessions never seem to expire. e.g if I add a timeout attribute like so : <sessionState...

ASP.NET

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

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

General

Navigating the Data Structures and Algorithms (DSA)

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...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

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...

Windows Server

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA