Installation Guides › Policy Server Installation Guide › Configuring SOA Security Manager Data Stores 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. Do one of the following:
   • If you are going to store Unicode characters in the session store, open sm_mssql_ss.sql.unicode in a text editor and copy the contents of the entire file.
   • If you are not going to store Unicode characters in the session store, 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 into the query.
5. Execute the query.

   The session store schema is created in the database.