Objective: When the Live Maps Portal is setup on a 2 or more different servers for high availability, the default session state configuration can cause problems. These include issues with refreshes, Sync Failure, and Authentication Failures after a period of time. 

This article assume you already have a SQL server up and running. It will detail how to setup the database and configure the Live Maps Portal to store session state in the database. 

1. Prepare your database to accept session state information. This can be done from the server hosting the Live Maps Portal. Be sure you are logged onto the server with a Windows Account that can create a database. 

From an Administrator command prompt, navigate to "c:\windows\microsoft.net\framework64\v4.0.30319" folder. This assume you are on a 64 bit system. 

Type the following command - aspnet_regsql.exe -S <SQL database instance> -E -ssadd -sstype p

I will explain what you are typing. 

aspnet_regsql.exe = the command to prepare a database for session state

-S <SQL database instance> = name the SQL instance name

-E = indicates Windows Authentication. 

-ssadd = adds the session state database

-sstype p = persistent


Once it is finished you will notice a new Database in the SQL instance. 

The Live Maps Portal App pool user must have db_owner

2. Configure the Live Maps portal. This should be done on all installations of the Live Maps Portal

First is to locate the web.config file for the Live Maps Portal. 

Best way to do this is to open the IIS Manager and navigate to the LiveMapsUnityPortal web Application OR the website hosting the Live Maps Portal. 

After you have located the web application, right click and select Explore

Keep in mind you may need to open this file up with administrative privileges. That may require extra steps. In this example i will be using Notepad++ to help highlight the changes. 

After the file is open locate the <sessionState> xml tag.

Copy and paste the code below.

  <sessionState cookieName="{7C5316E0-9A06-4D55-874B-30CEB65E20F5}-ASP.NET_SessionId" mode="SQLServer" sqlConnectionString="data source=<SQL Instance>; integrated security=SSPI" timeout="20" />

Change the <sql instance> to your SQL instance name. Example:

After you have made the changes save the file.

3. Live Maps Application Pool settings

Please double check the Load User Profile setting is set to TRUE. 

After you have set this to TRUE click on OK.

4. After everything is set, conduct an IISRESET and test.