Editing the connection to a Log Service database

The database for the Log Service stores system information and log entries. The database type can be Microsoft SQL Server or PostgreSQL.

  1. On the Global Settings tab, click Edit in the Database for Log Service section. The Database Connection dialog box opens. The subsequent steps of the description refer to the configuration of a Microsoft SQL Server database as an example. The connection settings for a PostgreSQL database are different.
  2. By default, the database server type Microsoft SQL Server is selected from the Database type list. You can select one of these options:
    • Microsoft SQL Server
    • PostgreSQL Server
  3. On the Connection tab, select the server on which the SQL Server database is located from the Select SQL server list.
  4. On the Schema tab, specify this information:
    User name
    Specify the name of the schema user.
    Password
    Specify the password of the schema user.
    Select database
    Select the Log Service database from the list. The default name is BIFarmLog.
    Note: On database level, the role db_owner must be assigned to the schema user.
  5. On the Options tab, specify the connection settings for the SQL Server as required. These settings are standard options for Microsoft SQL Server databases. For detailed information about the settings, refer to the Microsoft SQL Server documentation.
  6. Optionally, click Validate. Click OK twice to save the Log Service database settings and close the dialog box.
Related topics