Federation Manager 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 Federation Manager should use to connect to the database.

To configure the SQL Server wire protocol driver

1. Navigate to the directory federation_mgr_home/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_mgr_home/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.