Re: Configuring SQLServer Session State Storage on .NET 1.0 and 1.1

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Benjamin Fallar III (bfallar3_at_tri-isys.com)
Date: 06/05/04 

Date: Sat, 5 Jun 2004 12:22:32 +0800

try this link

820782 - Select a Database Name When You Use a SQL Server Session State in
ASP.NET

http://support.microsoft.com/default.aspx?scid=kb;en-us;820782

"TPataluch" <anonymous@discussions.microsoft.com> wrote in message
news:D816348B-FDBC-4B42-9F6B-A2E208CC974E@microsoft.com...
> I have an n-tier physical architecture that supports multiple ASP.NET
applications. The ASP.NET applications are configured to store session
state in SQL Server, all of which are using the same SQL Server machine.
>
> Both the .NET Framework 1.0 and 1.1 are running an all machines, since
some applications were developed under 1.0 while others use 1.1.
>
> My question is:
> The SQL Server database was originally created using the the
%windir%\Microsoft.NET\Framework\%version%\InstallSqlState.sql file from the
.NET Framework 1.0.
>
> My new ASP.NET application will be built leveraging the .NET Framework 1.1
and will require a session state database. If I create a new database using
the 1.1 .sql script, can it run concurrently with the old .NET Framework 1.0
session state database on the same server?
>
> Do I have a concrete business case for purchasing a new server because the
1.0 and 1.1 session databases cannot run on the same server?
>
> It appears that you can configure the SQLServer session state connection
string in each web application's web.config file, specifying the database
name. If so, could I configure the 1.0 applications to use DB1 and 1.1
applications to use DB2, both running on the same database server?
>
> Any feedback would be greatly appreciated.
> -Tom
>

Relevant Pages

  • Re: SQL Server corruption chance
    ... Database gets corrupted pretty often. ... >> just general statement about SQL Server stability and robustness. ... >> Server database corruption happening too? ... The proper way to implement Jet multi-user applications ...
    (microsoft.public.sqlserver.setup)
  • RE: Session state : SQLServer permissions
    ... ASPState are executed by a startup stored procedure in master. ... the last database is recovered at startup ... session state, your login account will need read/write permission to tempdb ... Session state data is stored in the SQL Server tempdb ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Stupid Manager Question
    ... > I am looking to convert database applications from Visual Fox Pro to a new ... We are also looking at putting SQL Server on our Web ... It's already been pointed out that ASP.NET is not a programming language, ...
    (microsoft.public.dotnet.general)
  • Re: Configuring SQLServer Session State Storage on .NET 1.0 and 1.1
    ... The ASP.NET applications are configured to store session ... state in SQL Server, all of which are using the same SQL Server machine. ... > The SQL Server database was originally created using the the ... and will require a session state database. ...
    (microsoft.public.dotnet.framework)
  • Re: Configuring SQLServer Session State Storage on .NET 1.0 and 1.1
    ... The ASP.NET applications are configured to store session ... state in SQL Server, all of which are using the same SQL Server machine. ... > The SQL Server database was originally created using the the ... and will require a session state database. ...
    (microsoft.public.dotnet.framework.setup)