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

Configure a SQL Server Policy Store

A single SQL Server database can function as a:

• policy store
• key store
• logging database

  Note: SOA Security Manager session information should be stored in a separate database. You should not use the policy store to store session information.

Using a single database simplifies administration tasks. The following sections provide instruction on how to configure a single database server to store SOA Security Manager data.

Consider the following:

• You can configure a SQL Server policy store manually or use the Policy Server installer to configure the policy store automatically.
• The database must be installed on a Windows system. Additionally, the SOA Security Manager schema files are installed with the Policy Server. If the Policy Server is installed on a UNIX system, copy the schema files from the policy_server_home/db/SQL directory to a temporary directory (C:\temp) on the Windows system to which the database is installed.