Where servers have been configured for load balancing to distribute workload across multiple computers or a computer cluster, it’s necessary to switch WealthWorks+ from using ASP State service, used for controlling state service is used to manage session state on one server, to SQL Server state. A SQL Server database is created in order to manage session states used by the WealthWorks+.

  1. To install the ASPState database on the required SQL Server instance, execute the following from a command prompt run as an Administrator. (Set the SQLServerName to the SQLServer instance where the ASPState database is to be maintained.
    C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regsql -S "<SQLServerName>" -E -ssadd -sstype p
    (this command is using windows authentication as denoted by -E)

  2. The following SQL command will also need to be executed from SQL Management Studio when connecting to the state server database using SQL authentication.

    use aspstate
    exec sp_changedbowner 'sa','true'

  3. Lastly the web.config file found in the WealthWorks+ virtual directory as installed on the IIS server will need to be edited to switch over to SQL State sessions.
    To configure WealthWorks+ to use SQL server session state:-
    <sessionState mode="SQLServer" sqlConnectionString="data source=servername;initial catalog=ASPState;uid=user;pwd=password;" useHostingIdentity="false" allowCustomSqlDatabase="true" cookieless="false" timeout="30" />

    Replace servername with SQL Server instance name and a valid user ID and password.