Installation Guides › Policy Server Installation Guide › Configuring SOA Security Manager Data Stores in a Relational Database › Configure SQL Server Data Stores › How to Store Session Information in SQL Server › Configure a SQL Server Data Source for SOA Security Manager › Configure the SQL Server Wire Protocol Driver

Configure the SQL Server Wire Protocol Driver

You configure the wire protocol driver to specify the settings SOA Security Manager uses 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 one of the following files and rename it system_odbc.ini. The file you rename depends on the database vendor you are configuring as a SOA Security Manager data store.

• sqlserverwire.ini
• oraclewire.ini
• mysqlwire.ini

These files are located in siteminder_home/db

The system_odbc.ini file contains the following sections. The data source that you are configuring determine the section or sections that you edit:

[SOA Security Manager Data Source]

Specifies the settings SOA Security Manager should use to connect to the database functioning as the policy store.

[SOA Security Manager Logs Data Source]

Specifies the settings SOA Security Manager should use to connect to the database functioning as the audit log database.

[SOA Security Manager Keys Data Source]

Specifies the settings SOA Security Manager should use to connect to the database functioning as the key store.

[SOA Security Manager Session Data Source]

Specifies the settings SOA Security Manager should use to connect to the database functioning as the session store.

[SmSampleUsers Data Source]

Specifies the settings SOA Security Manager 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 6 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/NSmsss24.so
   Description=DataDirect 6 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 to the Policy Server installation directory. This path cannot contain an environment variable.

   Example: export/smuser/siteminder

   SOA Security Manager 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. If you are using Microsoft SQL Server 2008 to function as any SOA Security Manager store, edit the [ODBC] section as follows:

   TraceFile=nete_ps_root/db/odbctrace.out
   TraceDll=nete_ps_root/odbc/lib/odbctrac.so
   InstallDir=nete_ps_root/odbc
   

   nete_ps_root

   Specifies the explicit path to the Policy Server installation directory. This path cannot contain an environment variable.

5. Save the file.

   The wire protocol driver is configured.