Running the Database Server Service on Log-In on Windows

When creating a database server with Configuration Wizard, the database service is configured to launch as an actual Windows service. This means it launches and allows clients to connect as soon as the machine is booted, without any user being signed-in.

Using Service Launcher, it is possible to configure your database server to only launch its database server service as the logged-in user, when they log-in. This means the database will only be accessible if the user configured to run it is logged in.

Although this may seem impractical, it may be preferable for security reasons. Services installed with the Configuration Wizard are run under the user usabatch, an user with administrator privileges which is created by Configuration Wizard to launch the services. When using Service Launcher, the logged-in user does not need to have administrator privileges to run services.

Before configuring Service Launcher to run the database server, the windows service that launches it must be disabled, so as to avoid launching two instances of the database server.

How to disable the database server service

1. Open the Start menu and, in the Programs menu, select Harmony 24 [Edition] > Tools > Control Panel.
2. When prompted, allow Control Panel to make changes to your device.

3. In the Process Starter drop-down, select HarmonyStarter0-tbdbserver.

   NOTE The number after HarmonyStarter may be different, depending on how many Harmony services were installed before this one.
4. Click on Stop.

5. Click on Remove.

   From that point on, the database server service will no longer launch on boot.

6. Close the Control Panel.

How to configure the database server to launch on user log-in

1. Make sure you are currently signed-in as the user who will run the service.

   NOTE This user will need to be logged in for the service to be running. The user does not need to have administrator privileges.

2. Do one of the following:

   • If Service Launcher is not running, open the Start menu and, in the Programs list, select Harmony 24 [Edition] > Tools > Service Launcher.
   • If Service Launcher is already running, click on its icon in the notification tray.

   The Service Launcher application launches.

3. In the Application parameters section of the Preferences tab, make sure that the Launch on login option is checked, so that services configured in Service Launcher automatically launch when you log in to your account.

4. Select the Database Server tab.
5. Click on Launch to verify that the database server launches successfully through Service Launcher.
6. Check the Launch when Service Launcher starts option.

7. In the top menu, select Server > Save All Settings.

   From now on, the database server will launch through Service Launcher when you log in.