ODBC user database

You can use an external database to hold all of the authentication information and properties for your users (with the exception of SSH user keys).

You must configure the ODBC user database before users can authenticate using this user database.

Before you can configure an ODBC user database, you must establish an ODBC system data source name through the Data Sources tool (found in the Windows Control Panel).

To configure an ODBC user database:

1. From the top menu, select Host > Host Details. The Host Details page opens.
2. Next to User database, click Configure. The User Database Configuration page opens.
3. Set the appropriate options.
   • Plug-in name. This is the name of the user plug-in. This is provided as information only and cannot be edited.
   • Plug-in location. This is the location of the DLL file for the user plug-in. This is provided as information only and cannot be edited.
   • Plug-in description. This is a description of the plug-in that describes its function. This is provided as information only and cannot be edited.
   • ODBC User DLL. Enter the full path to where the file obdcuser.dll was installed on the server. This is not the same as the ftpauthodbc.dll file listed in Plug-in location.
   • ODBC DSN. Enter the source name created in the ODBC Source Administration tool described above.
   • Table name. Enter the name of the database table that contains the correct fields. If you are using a Microsoft Access table with spaces in the name, you must enclose the table name in hard brackets; for example, [Table Name].
   • User ID and Password. If the database you are using requires authentication, enter a valid username and password.
4. Click Save.

Note: If you are configuring an external database that uses Windows credentials for authentication, such as Microsoft SQL Server, you must enter the credentials in the host impersonation fields on the Host Details page even if the credentials are already specified in the DSN and on the User Database Configuration page.