Editing Database Service

[[File:PRS Database Service Account Settings.png|none|thumb]]
The PRS database service is the engine room of PRS, providing access to one or more PRS databases.  In most cases, only one main database is required - however, there may be circumstances (for instance, multiple divisions or companies using the same infrastructure) where more than one database service may be running at the same time.

To add a database service, click the "Add Service" button at the bottom right of the screen, and select "Database":
[[File:PRS Add Database.png|none|thumb]]
The Database Properties screen will appear, allowing you to customise the service as required:
[[File:PRS Database Service General Settings.png|none|thumb]]

* The "Name" field provides a description of the database, which can be automatically provided to clients if the AutoDiscovery Service is enabled

* The "File Name" filed indicates the location of the (not-yet-created) database itself - click the "Select" button at the right to choose a location and file name for the database.  If you have an existing database file, you can select this here to use the existing data - it will not be overwritten or erased.
* The "Port" field indicates the TCP port that the database service will listen on for client requests.  This port should be configured to allow traffic through any firewalls you may have installed.

To ensure that the service can be validly installed on your system, click on the "Account" tab, and enter the Domain, User name and Password  for an account that has privileges to install services on your system:
[[File:PRS Database Server Account Details.png|none|thumb]]
(If you are using a local account, use "." as the Domain Name)

At this point you should see the Database Service appear in the list of available services:
[[File:PRS Database Service Status.png|none|thumb]]
The "Disk" image at the left indicates that this service is a Database.

The "Pause" image indicates that the service currently stopped - click this will start the service, after which the image will change to a "tick":
[[File:PRS Database Service - Running.png|none|thumb]]
Once the service is running, a "target" indicator will appear in the right-hand column - clicking this will display a debug console to allow you to monitor service activity:
[[File:PRS Database Console.png|none|thumb]]
Since this log is reset when the debug console is closed, a full log can be found in a log file which is saved to the "Local System" service account's AppData folder. This can be found under "C:\Windows\System32\config\systemprofile\AppData\Roaming\PRSServer\PRSDatabase" folder as a ".log" file.


Once the service is successfully running, you can move on to adding and configuring additional services as required:

* Add an [[AutoDiscovery Service|Auto Discovery Service]] to allow client workstations to automatically find and connect to this database
*Add a [[GPS Gateway Service]] to capture incoming GPS data from Digital Matter IoT devices
*Add a [[Scheduling Service|Scheduler Service]] to perform regular actions on you database
*