[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 408
  • Last Modified:

migrating session server 1.1 to 4.0

Session state is being used by legacy .net 1.1 application. Migrated to 4.0 and all is well except I get this error message.

any help would be much appreciated.
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.
   at System.Web.SessionState.SqlSessionStateStore.SqlPartitionInfo.GetServerSupportOptions(SqlConnection sqlConnection)
   at System.Web.SessionState.SqlSessionStateStore.SqlPartitionInfo.InitSqlInfo(SqlConnection sqlConnection)
   at System.Web.SessionState.SqlSessionStateStore.SqlStateConnection..ctor(SqlPartitionInfo sqlPartitionInfo, TimeSpan retryInterval)
   at System.Web.SessionState.SqlSessionStateStore.GetConnection(String id, Boolean& usePooling)
   at System.Web.SessionState.SqlSessionStateStore.SetAndReleaseItemExclusive(HttpContext context, String id, SessionStateStoreData item, Object lockId, Boolean newItem)
   at System.Web.SessionState.SessionStateModule.OnReleaseState(Object source, EventArgs eventArgs)
   at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Open in new window

  • 3
  • 2
1 Solution
sanagarwlAuthor Commented:
thanks you, do you know the options to use w/ Aspnet_regsql.exe

if you only type:
- aspnet_regsql.exe

a wizard will open to help you to configure  ("'next, next, next")

but you can automate in a batch file whit specific parameter (no wizard or humain interaction).
- aspnet_regsql.exe -E -S localhost -A mr
sanagarwlAuthor Commented:
thank you, one quick question - once I upgrade the session server db then will i still be able to run old 1.1 code against it.

We are in the process of migrating from 1.1 to 4.0 and may need to keep both code bases running before we "switch off" 1.1. Till this happens I wanted to know if both 1.1 and 4.0 codebases could point to the same session server db.

thank you again for the help.
I never try it, but I think you will need both database... 1.1 and 4.0.


Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now