Problem in Configuring ASPState DB for .NET 2.0

Hi,

In the current production environment we have web applications running in asp.net 1.1 (win 2003 server) which uses ASPState DB for the session management. We are in the process of migrating few of the web application in asp.net 2.0. We would like to use the same ASPState DB for both 1.1 and 2.0 applications for maintaining the session.

Problem that we are facing: After going through couple of article for configuring the ASPState DB, We ran the InstallPersistSqlState.sql of .net 2.0 framework (log information is given below). Though the sql has updated the existing ASPState DB with the stored procedure corresponding to asp.net 2.0, still we get the following error

Exception: System.Web.HttpException
Message: Unable to use SQL Server because ASP.NET version 2.0 Session State is not installed on the SQL server. Please install ASP.NET Session State SQL Server version 2.0 or above.

For certain reasons, we are not able to use aspnetreg_sql.exe for setting up the ASPState database. Is there something that I am missing when I run InstallPersistSqlState.sql alone.

Appreciate your help.

Thanks,

Siva

PS: We ran the InstallPersistSqlState.sql in the local sqlserver2000 (residing in winxp) and it works fine.

Result Log:

Run 'aspnet_regsql.exe -?' for details.
--

Completed execution of UninstallPersistSqlState.SQL
Starting execution of InstallPersistSqlState.SQL

--
Note:
This file is included for backward compatibility
only. You should use aspnet_regsql.exe to install
and uninstall SQL session state.
Run 'aspnet_regsql.exe -?' for details.
--
The CREATE DATABASE process is allocating 0.63 MB on disk 'ASPState'.
The CREATE DATABASE process is allocating 0.49 MB on disk 'ASPState_log'.
If the job does not exist, an error from msdb.dbo.sp_delete_job is expected.
Server: Msg 14262, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 61
The specified @.job_name ('ASPState_Job_DeleteExpiredSessions') does not exist.
(1 row(s) affected)
Type added.
(1 row(s) affected)
Type added.
(1 row(s) affected)
Type added.
(1 row(s) affected)
Type added.
(1 row(s) affected)
Type added.
If the category already exists, an error from msdb.dbo.sp_add_category is expected.
Server: Msg 14261, Level 16, State 1, Procedure sp_add_category, Line 32
The specified @.name ('[Uncategorized (Local)]') already exists.
-
Completed execution of InstallPersistSqlState.SQL
-

First of all, this is not the right place for posting a question about the ASP.NET Session DB, this is a CLR in SQLServer related forum only. But from the logs posted the db should have been installed. Make sure that you are trying to connect to the right session database from your web.config file. Also try to monitor if the passwort / username provided are right.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||Dod you solve the problem ?|||

Hi,

I got this problem resolved by running the aspnet_regsql.exe with command line options to setup the ASPState DB.

Anyways, Thanks for the suggestion.

Thanks,

Siva