Installation Guides › Policy Server Installation Guide › Configuring SOA Security Manager Data Stores 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: Be sure that you have gathered the required database information before beginning. Some of the following procedures require this information.

1. Be sure that the SQL Server database instance that is to contain the SOA Security Manager data is accessible from the Policy Server system.
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 SOA Security Manager super user password.
7. Import the default SOA Security Manager objects.
8. Import the policy store data definitions.
9. Restart the Policy Server.
10. Prepare for the Administrative UI registration.