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

problem in comparing date

Hi,

I have designed an employee portal. The moment the user logs in and logs out the current datetime will be stored.
Before the user logs out I should ensure whether he/she has entered the work done form for that day.

I wrote
select count(*) from workdone where work_date_time=getdate()
If there are any rows that means he/she has filled up the form else not filled.

But the query is comparing the date as well as time.
I want to compare only the date.
How should I reframe the query

Regards
cmrhema

Quote:

Originally Posted by cmrhema

Hi,

I have designed an employee portal. The moment the user logs in and logs out the current datetime will be stored.
Before the user logs out I should ensure whether he/she has entered the work done form for that day.

I wrote
select count(*) from workdone where work_date_time=getdate()
If there are any rows that means he/she has filled up the form else not filled.

But the query is comparing the date as well as time.
I want to compare only the date.
How should I reframe the query

Regards
cmrhema

SQL Server stores dates and time together. Depending on your application and how you are passing your date parameter in as part of your where clause (ie which part of the world you are in) you need to be mindful of your regional settings and look at the CONVERT function in SQL Server

SELECT CONVERT(char(10), GETDATE(), 103)

Will return getdate as character conversion based on the UK regional setting (103)

Regards

Jim :)

Problem in Calculating Total

Hi Everybody,

I need to generate report for all the days in a current month. I have to display the total in the folg. way.

Day1 Day2 etc.
Group Name sum of amount sum of amount
from day1 to end from day2 to end
of month of month

upto end of month.

I had a problem in setting the columns. And is there any way to calculate the group wise sum with out creating groups.

If you have any idea, pls. help me

Thanks,
harmonycitraHi,
I dont think it is possible to have groupwise total without creating group. You can group,find sum and suppress group header.

Madhivanan|||Thanks,

But I'd done it by Cross tab. The only difference is,

instead of starting from 1st to 31st, I reversed the order from end of month to beg. of month. So I'm calculating running total easily.

Any way, thank you!

Problem Deploying Reports when using SSL

Here is my current setup. I have Report Services sp1 installed on a Windows
2000 machine with SQL Server 2000. We have successfully configured RS to
produce reports over the internet via SSL. The actual viewing of the report
over the internet works great. However, in Visual Studio I receive the
following error when trying to deploy the reports...
"The underlying connection was closed. Could not establish trust
relationship with remote server"
The only work around I have found so far is to modify the
rsreportserver.config file and change secureconnectionlevel= from 2 to 0.
Then I am able to deploy the reports and do not receive this message.
Because SSL is a must, I then have to change the secureconnectionlevel= back
to 2.
Users externally are accessing the report server via
http://FQDN/reportserver. I had gone into the rswebapplication.config file
and changed <ReportServerUrl>http://server/reportserver<ReportServerUrl> to
<ReportServerUrl>http://FQDN/reportserver<ReportServerUrl> but no luck. My
certificate name uses the FQDN as the site name.
My question is why I am not able to deploy my reports when the SSL is turned
on?
I hope this makes sense and I am sure I left something out. Please let me
know your thoughts. Thanks!Sounds like you're hitting the issue in this KB article
http://support.microsoft.com/default.aspx?scid=kb;en-us;823177. Are you
specifying the FQDN in VS when deploying the reports?
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Tom" <Tom@.discussions.microsoft.com> wrote in message
news:B42B3849-C5FA-45AB-AEDA-D769D49ED57D@.microsoft.com...
> Here is my current setup. I have Report Services sp1 installed on a
> Windows
> 2000 machine with SQL Server 2000. We have successfully configured RS to
> produce reports over the internet via SSL. The actual viewing of the
> report
> over the internet works great. However, in Visual Studio I receive the
> following error when trying to deploy the reports...
> "The underlying connection was closed. Could not establish trust
> relationship with remote server"
> The only work around I have found so far is to modify the
> rsreportserver.config file and change secureconnectionlevel= from 2 to 0.
> Then I am able to deploy the reports and do not receive this message.
> Because SSL is a must, I then have to change the secureconnectionlevel=> back
> to 2.
> Users externally are accessing the report server via
> http://FQDN/reportserver. I had gone into the rswebapplication.config
> file
> and changed <ReportServerUrl>http://server/reportserver<ReportServerUrl>
> to
> <ReportServerUrl>http://FQDN/reportserver<ReportServerUrl> but no luck.
> My
> certificate name uses the FQDN as the site name.
> My question is why I am not able to deploy my reports when the SSL is
> turned
> on?
> I hope this makes sense and I am sure I left something out. Please let me
> know your thoughts. Thanks!
>