Installation and Upgrade Guides › Policy Server Installation Guide › Configuring SiteMinder Data in a Relational Database › Configure SQL Server Data Stores › How to Store Audit Logs in SQL Server › Configure a SQL Server Data Source for SiteMinder › Configure the SQL Server Wire Protocol Driver

Configure the SQL Server Wire Protocol Driver

You configure the wire protocol driver to specify the settings SiteMinder should use to connect to the database.

Note: This procedure only applies if the Policy Server is installed on a UNIX system. If you have not already done so, copy and rename oraclewire.ini to system_odbc.ini, which is located in <policy_server_installation>/db.

The system_odbc.ini file contains the following sections. The sections you edit are determined by the data source you are configuring:

• [SiteMinder Data Source]

  Specifies the settings SiteMinder should use to connect to the database functioning as the policy store.

• [SiteMinder Tokens Data Source]

  Specifies the settings SiteMinder should use to connect to the database functioning as the token store.

• [SiteMinder Logs Data Source]

  Specifies the settings SiteMinder should use to connect to the database functioning as the audit log database.

• [SiteMinder Keys Data Source]

  Specifies the settings SiteMinder should use to connect to the database functioning as the key store.

• [SiteMinder Session Data Source]

  Specifies the settings SiteMinder should use to connect to the database functioning as the session store.

• [SmSampleUsers Data Source]

  Specifies the settings SiteMinder should use to connect to the database functioning as the sample user data store.

To configure the wire protocol driver

1. Open the system_odbc.ini file.
2. Enter the following under [ODBC Data Sources]:

   SiteMinder Data Source=DataDirect 5.3 SQL Server Wire Protocol.
   

3. Depending on the data source you are configuring, edit the one or more of the data source sections with the following information:

   Driver=nete_ps_root/odbc/lib/NSmass23.so
   Description=DataDirect 5.3 SQL Server Wire Protocol
   Database=SiteMinder Data
   Address=myhost, 1433
   QuotedId=No
   AnsiNPW=No
   

   Note: When editing data source information, do not use the pound sign (#). Entering a pound sign comments the information, which truncates the value. The truncated value may cause ODBC connections to fail.

   • nete_ps_root

     Specifies an explicit path, rather than one with an environment variable.

     Example: export/smuser/siteminder

   • SiteMinder Data

     Specifies the SQL Server database instance name.

   • myhost

     Specifies the IP Address of the SQL Server database.

   • 1433

     Represents the default listening port for SQL Server.

4. Save the file.

   The wire protocol driver is configured.