Configure the SQL Server Wire Protocol Driver

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

You configure the wire protocol driver to specify the settings SiteMinder 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 SiteMinder 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:

[SiteMinder Data Source]: Specifies the settings SiteMinder is to use to connect to the database functioning as the policy store.
[SiteMinder Logs Data Source]: Specifies the settings SiteMinder is to use to connect to the database functioning as the audit log database.
[SiteMinder Keys Data Source]: Specifies the settings SiteMinder is to connect to the database functioning as the key store.
[SiteMinder Session Data Source]: Specifies the settings SiteMinder is to connect to the database functioning as the session store.
[SmSampleUsers Data Source]: Specifies the settings SiteMinder is to connect to the database functioning as the sample user data store.

Follow these steps:

Open the system_odbc.ini file.

Enter the following under [ODBC Data Sources]:

SiteMinder Data Source=DataDirect 6 SQL Server Wire Protocol.

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

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.
If you are using Microsoft SQL Server 2008 to function as any SiteMinder 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.
Save the file.
The wire protocol driver is configured.

Point the Policy Server to the Database

You point the Policy Server to the database so the Policy Server can access the SiteMinder data in the policy store.

Follow these steps:

Open the Policy Server Management Console and click the Data tab.
Select the following value from the Storage list:
```
ODBC
```
Select the following value from the Database list:
```
Policy Store
```
Enter the name of the data source in the Data Source Information field.
- (Windows) The entry must match the name that you entered in the Data Source Name field when you created the data source.
- (UNIX) The entry must match the first line of the data source entry in the system_odbc.ini file. By default, the first line in the file is [SiteMinder Data Sources]. If you modified the first entry, be sure to enter the correct value.
Enter and confirm the user name and password of the database account that has full access rights to the database instance in the respective fields.
Specify the maximum number of database connections that are allocated to SiteMinder.
Note: We recommend retaining the 25 connection default for best performance.
Click Apply to save the settings.
Select the following value from the Database list:
```
Key Store
```
Select the following value from the Storage list:
```
ODBC
```
Select the following option:
```
Use the Policy Store database
```
Select the following value from the Database list:
```
Audit Logs
```
Select the following value from the Storage list:
```
ODBC
```
Select the following option:
```
Use the Policy Store database
```
Click Apply to save the settings.
Click Test Connection to verify that the Policy Server can access the policy store.
Click OK.
The Policy Server is configured to use the database as a policy store, key store, and logging database.