When multiple Primavera Portfolio Management Front-End servers have been installed and are operating in a load-balancing cluster, or when PPM database is hosted on Microsoft SQL Server, create an ASPState database for persisting session information as follows:
- Select a Windows server on which the Primavera Portfolio Management Front-End has been installed.
- Run Microsoft SQL Server Query Analyzer.
- Login to Microsoft SQL Server hosting the PPM database, using the “sa” database login.
- From the File menu, select Open.
- On the local drive, browse to \WINDOWS\Microsoft.NET\Framework\v2.0.50727.
- Select installpersistsqlstate.sql.
- From the Query menu, select Execute.
The ASPState database is created.
- When finished, close Microsoft SQL Server Query Analyzer.
- Open Microsoft SQL Server Enterprise Manager.
- Create a new SQL Server login called ASPState.
- Set the properties for ASPState login as follows:
- Use SQL Server authentication and specify a password
- Set the default database to ASPState
- On the Database Access tab, allow access to the ASPState database only, as user ASPState, and grant public and db_owner roles.