Administrator Guide

186 | Preparing W-ClearPass for LDAP and SQLAuthenticationSources Dell Networking W-ClearPass Deployment Guide
Primary Page
Figure 152 Primary Page: Generic SQL Authentication Source
10. Enter the information for each of the required parameters as described in Table 36.
Table 36: Primary Page Parameters for Generic SQL Database
Parameter Action/Description
Server Name
Enter the name or IP address of the Generic SQL server you’re going to use for
authentication.
Port Optionally, you can specify a port value to override the default port.
Database Name Enter the name of the database from which records can be retrieved.
Login Username
Enter the name of the user used to log into the database. This account must have
read access to all the attributes that need to be retrieved by the specified filters.
Password Enter the password for the user account entered in the Login Username field.
Timeout
Enter the duration in seconds that Policy Manager waits before attempting to fail
over from the primary to the backup servers (in the order in which they are
configured).
ODBC Driver
Select the ODBC driver (Postgres, Oracle11g, or MSSQL) to connect to the database.
NOTE: MySQL is supported in versions 6.0 and later. Dell does not ship MySQL drivers
by default. If you require MySQL, contact dell.com/support to get the required patch.
This patch does not persist across upgrades. If you are using MySQL, you should
contact support before upgrading.
Password Type Specify how the user password is stored in the database: