Running the Workgroup Engine as a Service
By default, the Workgroup engine is installed to run as an application. During a Custom installation you may configure your workstation to run the Workgroup engine as a service rather than as a console application. Running the engine as a service allows the engine to start automatically when the operating system starts. A user is not required to log in to start the engine.
No tray icon appears when you run the Workgroup engine as a service.
Configuration
In order to configure your Workgroup engine to run as a Service as opposed to an application, you must reinstall the Pervasive PSQL v11 SP3 Workgroup engine. Choose the Custom install and select Run As Service on the Engine Settings dialog box during install.
*Caution: Running the engine as a service requires the Log On as Service privilege. If you select to run the engine as a service under a user account other than the default Local System account, you will need to modify the Log On Properties for the Service using the Windows Control Panel.
Note that on Windows platforms, a valid user name and password are required to access Pervasive PSQL databases on another machine. "System Account" has no rights on other machines to Pervasive PSQL databases.
If you want the Pervasive Workgroup service to access databases on another machine, then you must specify a valid user name and password for the other machine, unless there is a running Pervasive Workgroup available locally on the other machine that can be used to access the databases instead. Access the properties for the Pervasive Workgroup service. (Double-click the service on the Services dialog.) In the Log On As section, check This Account and specify a valid user name and password.
Stopping the Service
If you want to stop and then restart the service (and not permanently remove the service), then just reboot the machine.
You stop the service on Windows platforms just as you would any other service.
►
Stopping the Engine as a Service on Windows
1
In the Windows Control Panel, click Administrative Tools, then double-click Services.
2
Right-click the service name assigned to the Workgroup engine and click Stop.