Editing the repository database

This section describes how to edit the repository database.
  1. In the Repository and Access step, click Database. The Database Connection dialog box opens. The subsequent steps of the description refer to the configuration of a Microsoft SQL database as an example. The connection settings for a PostgreSQL database are different.
  2. On the Connection tab, select the server on which the SQL Server database is located from the Select SQL server list.
  3. 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 database from the list. The default name is BIFarmRepository.
    Note: On database level, the role db_owner must be assigned to the schema user.
  4. 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.
  5. Optionally, click Validate. If the test is successful, the message The connection test was successful. is displayed. Click OK twice to close the dialog box.