Installation and Upgrade Guides › Policy Server Installation Guide › Configuring SiteMinder 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: Store SiteMinder session information in a separate database. Do 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 SiteMinder data.

Consider the following items:

• You can configure a SQL Server policy store manually or you can use the Policy Server installer to configure the policy store automatically.
• The database must be installed on a Windows system. Additionally, the SiteMinder 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 on the Windows system.

Gather Database Information

Configuring a single SQL Server database to function as a policy store or any other type of SiteMinder data store requires specific database information.

Note: Information prefixed with (W) indicates that the information is only required if the Policy Server is installed on a Windows system; (U) indicates that the information is only required if the Policy Server is installed on a UNIX system. Different information is required when configuring the SQL Server data source.

Gather the following information before configuring the policy store or any other type of SiteMinder data store. You can use the SQL Server Information Worksheet to record your values.

Note: Policy and data store worksheets are provided to help you gather and record information before configuring or upgrading a SiteMinder data store. You can print the applicable worksheet and can use it to record required information before beginning.

• Database instance name —Determine the name of the database instance that is to function as the policy store or data store.
• Administrative account —Determine the user name of an account with privileges to create, read, modify, and delete objects in the database.
• Administrative Password —Determine the password for the Administrative account.
• (W) Data source name —Determine the name you will use to identify the data source.

  Example: SM SQL Server Wire DS.

• (W) SQL Server name —Determine the name of the SQL Server database that contains the instance that is to function as the policy store.
• (U) Policy Server root —Determine the explicit path to where the Policy Server is installed.
• (U) IP Address —Determine the IP Address of the SQL Server database.

More information:

SQL Server Information Worksheet