9.3 Configuring Databases

Self Service Password Reset uses two types of databases:

  • Local Database: Self Service Password Reset uses a local database for storing local data. The local database requires no administration or maintenance and the default values are sufficient.

  • External Database: Self Service Password Reset uses an external database to store data for certain functions. Any standard JDBC database that supports a standard Java JDBC driver works. Self Service Password Reset connects to the database and creates the necessary tables. You can configure multiple Self Service Password Reset instances to the same database instance. Self Service Password Reset officially supports MS SQL database and Oracle database.

You must manually configure the database to save the challenge-response information from Self Service Password Reset. You must work with a database administrator to complete the tasks.

To configure the database:

  1. Create a database.

    For more information about how to create a database, see the related product documentation.

  2. Create a database administrator for that database. You must specify this administrator during Self Service Password Reset configuration.

  3. Create a user and associate it with the database you created in Step 1.

  4. (Conditional) If you are using the Microsoft SQL database, ensure that the user has enabled the SQL server authentication mode and has suitable rights to open the database, which is the SQL Server Authentication mode. For more information, see Choosing an Authentication Mode.