migrating session server 1.1 to 4.0

Posted on 2011-05-12
Last Modified: 2012-05-11
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

Question by:sanagarwl
    LVL 7

    Expert Comment


    Author Comment

    thanks you, do you know the options to use w/ Aspnet_regsql.exe

    LVL 7

    Accepted Solution

    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

    Author Comment

    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.
    LVL 7

    Expert Comment

    I never try it, but I think you will need both database... 1.1 and 4.0.


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now