Skip to main content

Basic configuration

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 Server Manager is started and can be called up at any time in the basic configuration.

base configuration

The basic configuration​

A special wizard is available to carry out the configuration:

Baseconfig

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 Server Manager can also access the SQL server.

The loopback address 127.0.0.1 should not be used here.

Service user​

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.

CAUTION: The defined service user needs local administrator rights to properly configure the server and create databases.

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.

installation_with_parameters_190

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”.

NOTE: Refer to the system requirements for server section for more information about the users.

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 Server Manager. However, you can also choose your own. Further information can be found directly in the section provided for this purpose.

CAUTION: Exchanging or overwriting an existing certificate may cause warnings to the clients if the certificate is not trusted by each client.

Allow host mode

Host mode is no longer supported since version 8.13.

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

NOTE: If this option is changed, the server needs to be restarted so that the change can take effect.