8.2 Adding an SQL Database

IMPORTANT:The SQL Database is not available in Advanced Authentication as a Service (SaaS) version.

You can add an MSSQL database to be consumed as a repository by Advanced Authentication. The following version of SQL servers are supported:

  • Microsoft SQL Server 2016

To add an SQL database, perform the following steps:

  1. Click Repositories > New SQL repo.

  2. Specify the following details of the SQL database:

    • Name: Name of the repository.

    • Database type: Select MSSQL.

    • DB host: IP address of the database host.

    • DB name: Name of the database.

    • DB user: Name of the database user.

    • Password: Password of the database.

    • Table or view name: Name of the table or view in the database.

    • User’s id column and User’s id type: User’s id column and id type in the database.

    • User’s name column and User’s name type: The username column and the type in which the name is specified.

    • User's phone column, and User's email column: The phone and email column in the database.

IMPORTANT:Remember the following points:

  • The LDAP Password method is not applicable for the users in SQL repository. The Password method for the users is not enrolled automatically and can be enrolled manually by the Helpdesk administrator only.

  • You must disable the Ask credentials of management user in the Helpdesk Options policy for the SQL repository. This enables the helpdesk administrator to set an authenticator for a user, without getting authenticated with the user's password on the User to Manage page of the Helpdesk portal.

  • The SQL repository supports auto enrollment of Email OTP, SMS OTP, and Voice OTP methods. If you use only these methods, you can create a chain with one or some of these methods. You do not need the Helpdesk administrator’s assistance for the enrollment of these methods. It is not recommended to use a single factor chain with only one of these methods as it is not secure.