What is basic configuration?

Within the basic configuration, the connection to the SQL server or to the databases is defined. The basic configuration appears the first time the AdminClient is started and can be called up at any time in the basic configuration.

The basic configuration

A special wizard is available to carry out the configuration:

Service address

The service address of the SQL server can be selected via the drop-down menu. It is mandatory to select the adapter via which the AdminClient can also access the SQL server.

Service user

This setting is used to define the service user, which is needed to start the server service as well as the backup service. The “Use local system” setting starts the services with the local system account.

SQL configuration instance

Under “SQL Server instance” the database server must be specified, including the SQL instance. For simplicity, you can copy the server name from the login window of the SQL server.

If the option “Service user” is selected, enter the user that logs on to the SQL Server. Please note that “dbCreator” rights are necessary to create a configuration database. “dbOwner” rights are sufficient if the database is created manually on the SQL server and is only accessed here. Enter the name of the configuration database under “Database”.

Expert mode

Expert mode displays additional menu options for advanced configurations:

Backup service user

You can use a dedicated user to run the backup here. The service user is selected by default.

SQL configuration instance

This menu item can be configured in expert mode via a so-called connection string.

Certificate

The SSL connection certificate can also be configured under this item to protect the client server connection. By default, a certificate is generated by the AdminClient. However, you can also choose your own. Further information can be found directly in the section provided for this purpose.

Allow host mode

Host mode is not yet supported in the current version and thus should not be used.

Activating caching

Caching is activated by default to improve performance. The so-called SqlBroker is registered for the database on the SQL server here. The following is cached:

  • The roles of the individual users
  • The structure of the organisational units
  • All settings

Click here to return to the “Getting started” section

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.