• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 413
  • 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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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