Where servers have been configured for load balancing to distribute workload across multiple computers or a computer cluster, it is 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+.
- 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) - 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' - 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.