Editing the connection to a Configuration Service database

The database for the Configuration Service stores information about active sessions and tenants, resources, service managers and workers, and system information. The database type can be Microsoft SQL Server or PostgreSQL.

On the Global Settings tab, click Edit in the Database for Configuration Service section. 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.

Note: The Edit button is active only when you are disconnected from the services. Click Expert > Disconnect.
On the Connection tab, select the server on which the SQL Server database is located from the Select SQL server list.
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 Configuration Service database from the list. The default name is BIFarmConfig.

Note: On database level, the role db_owner must be assigned to the schema user.
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.
Optionally, click Validate. Click OK twice to save the Configuration Service database settings and close the dialog box.