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.

NOTE While Windows services run regardless of who is logged in and even when no user is logged-in, Service Launcher will only run when the user for which it was specifically configured is logged in. This means that if you want Service Launcher to launch when any user is logged in, you must configure it for each user that has access to the machine.