Installation Guides › Policy Server Installation Guide › Configuring SOA Security Manager Data Stores in a Relational Database › Configure SQL Server Data Stores › How to Store Key Information in SQL Server › Create the Key Store Schema

Create the Key Store Schema

You create the key store schema so the SQL Server database can store key information.

To create the key store schema

1. Open sm_mssql_ps.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_ps.sql into the query.
5. Execute the query.

   The SOA Security Manager key store schema is created in the database.