Installation and Upgrade Guides › Policy Server Installation Guide › Configuring SiteMinder Data in a Relational Database › Configure SQL Server Data Stores › How to Store Session Information in SQL Server › Create the Session Store Schema

Create the Session Store Schema

You create the session store schema so the SQL Server database can store and read session information.

To create the session store schema

1. Open sm_mssql_ss.sql in a text editor and copy the contents of the entire file.
2. Start the Query Analyzer and log in as the who administers the Policy Server database.
3. Select the database instance from the database list.
4. Paste the schema from sm_mssql_ss.sql into the query.
5. Execute the query.

   The session store schema is created in the database.