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

How to Configure the Policy Store

Complete the following procedures to configure a SQL Server database as a policy store:

Note: Ensure you have gathered the required database information before beginning. Some of the following procedures require this information.

1. Make sure the SQL Server database instance that is to contain the SOA Security Manager data is accessible from the Policy Server machine.
2. Using the SQL Server Enterprise Manager, create the database instance for the SOA Security Manager data store.

   Example: smdatastore.

3. Create the SOA Security Manager Schema.
4. Configure a SQL Server Data Source for SOA Security Manager.
   • (Windows) Create a SQL Server Data Source.
   • (UNIX) Create a SQL Server Data Source on UNIX Systems.
   • (UNIX) Configure the SQL Server Wire Protocol Driver.
5. Point the Policy Server to the Database.
6. Set the SiteMinder Super User Password.
7. Import the Default SOA Security Manager Objects.
8. Import the Policy Store Data Definitions.
9. Restart the Policy Server.