Required database information for IQ Bot installation

When you install IQ Bot, you are prompted to provide information specific to the database type you are using. The following table summarizes the required information.

Microsoft SQL Server and Amazon RDS databases
Required information Description
Database (SQL Server) authentication Provide credentials for a Microsoft SQL Server user who has permission to connect to the database.
Database names
  • AliasData
  • ClassifierData
  • Configurations
  • FileManager
  • MLData
Database port Default: 1433
Service credentials Provide the user with the following permissions:
  • CONNECT SQL
  • CREATE ANY DATABASE
  • VIEW ANY DATABASE
Microsoft Azure database
Required information Description
Database (SQL Server) authentication Created when database was created.
Database names
  • FileManager
  • Classifier
  • Configurations
  • MLData
  • AliasData
Database port Default: 1433
Database role Database access requires the dbmanager role.