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
6  1352 
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.publi c.dotnet.framew ork.aspnet
NNTP-Posting-Host: cpe.atm2-0-1061199.0x50a63 bf2.bynxx13.cus tomer.tele.dk
80.166.59.242Path: cpmsftngxa06.ph x.gbl!TK2MSFTNG P08.phx.gbl!TK2 MSFTNGP10.phx.g bl
Xref: cpmsftngxa06.ph x.gbl microsoft.publi c.dotnet.framew ork.aspnet:1919 18
X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.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
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******@onlin e.microsoft.com > skrev i en meddelelse
news:G$******** ******@cpmsftng xa07.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.publi c.dotnet.framew ork.aspnet
NNTP-Posting-Host: cpe.atm2-0-1061199.0x50a63 bf2.bynxx13.cus tomer.tele.dk
80.166.59.242Path: cpmsftngxa06.ph x.gbl!TK2MSFTNG P08.phx.gbl!TK2 MSFTNGP10.phx.g bl
Xref: cpmsftngxa06.ph x.gbl
microsoft.publi c.dotnet.framew ork.aspnet:1919 18X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.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
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.publi c.dotnet.framew ork.aspnet
NNTP-Posting-Host: cpe.atm2-0-1061199.0x50a63 bf2.bynxx13.cus tomer.tele.dk
80.166.59.242Path:
cpmsftngxa07.ph x.gbl!cpmsftngx a10.phx.gbl!TK2 MSFTNGXA05.phx. gbl!TK2MSFTNGP0 8
.phx.gbl!tk2msf tngp13.phx.gblXref: cpmsftngxa07.ph x.gbl microsoft.publi c.dotnet.framew ork.aspnet:1914 89
X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.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******@onlin e.microsoft.com > skrev i en meddelelse
news:G$******* *******@cpmsftn gxa07.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.publi c.dotnet.framew ork.aspnet
>NNTP-Posting-Host:
cpe.atm2-0-1061199.0x50a63 bf2.bynxx13.cus tomer.tele.dk 80.166.59.242 >Path: cpmsftngxa06.ph x.gbl!TK2MSFTNG P08.phx.gbl!TK2 MSFTNGP10.phx.g bl
>Xref: cpmsftngxa06.ph x.gbl
microsoft.publ ic.dotnet.frame work.aspnet:191 918 >X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.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
>
>
>
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
allowCustomSqlD atabase attibute in web.config)
If any body has an idea or knows how to "hack" it, please write back
Agge
"Jim Cheshire [MSFT]" <ja******@onlin e.microsoft.com > skrev i en meddelelse
news:G$******** ******@cpmsftng xa07.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.publi c.dotnet.framew ork.aspnet
NNTP-Posting-Host: cpe.atm2-0-1061199.0x50a63 bf2.bynxx13.cus tomer.tele.dk
80.166.59.242Path: cpmsftngxa06.ph x.gbl!TK2MSFTNG P08.phx.gbl!TK2 MSFTNGP10.phx.g bl
Xref: cpmsftngxa06.ph x.gbl
microsoft.publi c.dotnet.framew ork.aspnet:1919 18X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.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
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.publi c.dotnet.framew ork.aspnet
NNTP-Posting-Host: cpe.atm2-0-1061199.0x50a63 bf2.bynxx13.cus tomer.tele.dk
80.166.59.242Path:
cpmsftngxa06.ph x.gbl!TK2MSFTNG XA06.phx.gbl!TK 2MSFTNGXA05.phx .gbl!TK2MSFTNGP 0
8.phx.gbl!TK2MS FTNGP11.phx.gblXref: cpmsftngxa06.ph x.gbl microsoft.publi c.dotnet.framew ork.aspnet:1934 85
X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.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
allowCustomSql Database attibute in web.config)
If any body has an idea or knows how to "hack" it, please write back
Agge
"Jim Cheshire [MSFT]" <ja******@onlin e.microsoft.com > skrev i en meddelelse
news:G$******* *******@cpmsftn gxa07.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.publi c.dotnet.framew ork.aspnet
>NNTP-Posting-Host:
cpe.atm2-0-1061199.0x50a63 bf2.bynxx13.cus tomer.tele.dk 80.166.59.242 >Path: cpmsftngxa06.ph x.gbl!TK2MSFTNG P08.phx.gbl!TK2 MSFTNGP10.phx.g bl
>Xref: cpmsftngxa06.ph x.gbl
microsoft.publ ic.dotnet.frame work.aspnet:191 918 >X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.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
>
>
>
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******@onlin e.microsoft.com > skrev i en meddelelse
news:ES******** ******@cpmsftng xa06.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.publi c.dotnet.framew ork.aspnet
NNTP-Posting-Host: cpe.atm2-0-1061199.0x50a63 bf2.bynxx13.cus tomer.tele.dk
80.166.59.242Path:
cpmsftngxa06.ph x.gbl!TK2MSFTNG XA06.phx.gbl!TK 2MSFTNGXA05.phx .gbl!TK2MSFTNGP 0 8.phx.gbl!TK2MS FTNGP11.phx.gblXref: cpmsftngxa06.ph x.gbl
microsoft.publi c.dotnet.framew ork.aspnet:1934 85X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.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
allowCustomSql Database attibute in web.config)
If any body has an idea or knows how to "hack" it, please write back
Agge
"Jim Cheshire [MSFT]" <ja******@onlin e.microsoft.com > skrev i en
meddelelsenews:G$******* *******@cpmsftn gxa07.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.publi c.dotnet.framew ork.aspnet
>NNTP-Posting-Host:
cpe.atm2-0-1061199.0x50a63 bf2.bynxx13.cus tomer.tele.dk 80.166.59.242
>Path: cpmsftngxa06.ph x.gbl!TK2MSFTNG P08.phx.gbl!TK2 MSFTNGP10.phx.g bl
>Xref: cpmsftngxa06.ph x.gbl
microsoft.publ ic.dotnet.frame work.aspnet:191 918 >X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.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
>
>
>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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 maintain session state in sqlserver, Does
anybody knows when it's saved to database?, on
beguinSession, on endSession...
<sessionState
|
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 page request?
- will each reading of a session variable cause a round
trip to the DB server? or does the complete session live
within the HttpContext object?
- when asp.net session state is enabled (in any mode),
after a session has been created,...
|
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 working.
I ran uninstallsqlstate.sql after stopping w3svc and then restarted
the w3svc and rean installsqlstate.sql. This works fine on my machine
and my session variables work again....but I'm an administrator on the
database. I go to another...
|
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
|
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.:
ayzuglzyznc4o4eplcu1h2bj
The corresponding database value
(ASPState.ASPStateTempSessions.SessionID) is a 32-character string
which equates to the 24-character Session.SessionID value plus
"00000001":
| | |
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. They
require us to use the tool to encrypt the connection strings to the
"real" database. We have had no problem with that.
However, they also want to use SQL Server to manage session state, and
would really like the ConnectionString to the...
|
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
|
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 when we use InProc session
state, when we change to SQLServer mode for this website, it does not
work--session variables are not retained page to page (and no errors are
raised indicating a problem). The second website is using the same...
|
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 mode="SQLServer"
sqlConnectionString="Integrated Security=SSPI;data source=localhost"
timeout="1" >
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
