Setting up the Client/Server Database Server as a Service

Windows servicesRunning a server application as a service has some definite advantages. The most significant advantage is that when the server is running as a service it can be configured so that no user is required to be logged in on the server machine. Another advantage is that services can be configured to automatically restart if the server ever has to be restarted.

Several CyberMatrix products have client/server editions. Some other products have client/server options. Pro Schedule, Meeting Manager, Project Clock and Timesheets all have a client/server edition. Employee Project Clock and CyberMatrix Point Of Sale have an option to use the software in a client/server configuration. The server for all these products can be configured to run as a service.

 Before Installing the Server as a Service

There are a few steps you should perform before installing the server application as a service.

  1. Verify the server IP address.
    Run the server application. You will see an orange icon is the system tray. Double click that to see the ElevateDB server manager. Click the icon in the upper left that says “Stop Server”. Click the icon below that says “Edit Server Options”. Under the Connections tab you can change the IP address if you had set it wrong during installation or if the IP has changed. If you make the IP address field blank, all IP addresses will be listened for.
  2. Set the temp folder.
    In the Miscellaneous tab of the “Edit Server Options” you should verify the server temporary folder. For a service you should ensure that the user the service will run under will have full write access for the temp folder used. In particular you should not use any user folders as they may not exist later on.
  3. Run first as a non-service application.
    Before running the server as a service, run the server as a non-service application to verify that there are no problems like obvious folder rights issues or firewall issues.
  4. Configure your firewall.
    Make sure there is an application exception for the server application. Also make sure that the port used (default 12010) is opened in the firewall.

Installing the Server as a Service

To install the edbsrvr.exe database server as a service, enter the following command at a command line prompt or from the Run Menu:
edbsrvr.exe /install

To install the database server so that it does not interact with the desktop at all, which is required in instances where the current user will be logged out of the system, you should use the /nointeract flag along with the /install command-line switch:
edbsrvr.exe /install /nointeract

This will install the service as a non-interactive service and the database server will not display a user interface when it is started.

Starting the Server Service

To start the edbsrvr.exe database server as a service enter the following command at a command line prompt or from the Run Menu:
net start edbsrvr

Uninstalling the Server Service

To uninstall the service first stop it and then type:

edbsrvr.exe /uninstall

Summary
Setting up the Client/Server Database Server as a Service
Article Name
Setting up the Client/Server Database Server as a Service
Description
Explains how to setup the server of CyberMatrix client/server software as a Windows service.
Author
Publisher
CyberMatrix
Publisher Logo

Leave a Reply