Previous Topic: Configure the Oracle Wire Protocol DriverNext Topic: Test a User Directory Connection from the Directory List

CA SiteMinder® Federation Standalone Guide › User Directory Connections for Authentication › ODBC Directory Connection › ODBC Data Source on Solaris Configuration Requirement › Configure the SQL Server Wire Protocol Driver

Configure the SQL Server Wire Protocol Driver

You configure the SQL wire protocol driver to specify the settings CA SiteMinder® Federation Standalone uses to connect to the database.

To configure the SQL Server wire protocol driver

  1. Navigate to the directory federation_install_dir/siteminder/db.
  2. Open the system_odbc.ini file in a text editor.
  3. Select the section [CA FedManager Data Source] and make a copy of it directly under its current location.
  4. Using the copy you created as a template, rename the heading in brackets to something appropriate for your data source.
  5. Change the values and add new entries so that the modified text for the SQL Server data source appears as follows: 
    Driver=federation_install_dir/siteminder/odbc/lib/NSmass23.so
Description=DataDirect 5.0 SQL Server Wire Protocol
Database=database_instance
Address=host_IP_address, port_number (default: 1433)
QuotedId=No
AnsiNPW=No
  6. Save the file.

    The wire protocol driver is configured.

Important! Do not modify other settings in this file, especially anything listed in the [CA FedManager Data Source] section.