Setting up the GP Manager for server operation

Release of the GP Manager for working with multiple workstations

  1. Share the GP Manager folder. Click with the right mouse button on the GP Manager link and select "Open file path„
  2. Select the parent folder in the address bar and then right-click on the GP Manager installation folder (default: c:\GeBioM_SQL or c:\GPM_V7).
    In the context menu, select Properties -> Release -> Extended release -> Authorisations enter the folder for the group "Everyone" with the authorisation Full access free.

Release of the database for the workstations

To ensure that the database is not only available locally, the database must be configured so that it can be accessed externally.

  1. First start the SQL Server Configuration Manager for your SQL Express version. You can find this in the start menu via "All programmes" -> "Microsoft SQL Server 20XX" -> "Configuration tools"-> "SQL Server 20XX Configuration Manager“
    • For Windows 10, the Manager is no longer displayed under "All apps" as it is a snap-in. Search for C:\Windows\SysWOW64\QLServerManager12.msc for the 2014 version. Older versions have smaller numbers. Alternatively, you can search your drives for SQLServerManager*.msc.
  2. In the configuration manager on the left, select "SQL Server network configuration" you can then see the SQL instances that are currently running on the server. Depending on the GP Manager version, select the instance GEBIOM resp. GEBIOMV7. Then activate "Named Pipes" and "TCP/IP" for the instance.

An exception may need to be entered in the server's firewall so that the individual workstations can access the database. As the path to the service differs depending on the version installed, first make sure that the path to the SQL service is correct.

  1. Check the path by entering a Right click on Computer make. Select "Manage" -> "Services and applications" -> "Services" -> "SQL Server (instance name)„
  2. Right-click on the service and select "Properties". Copy the "Path to the EXE file„.
  3. Enter the Port 1433 and 1434 in the firewall for this service.
  4. Allow access for the SQLBrowser.exe, This is located in a standard installation under : C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe

Make sure that the services for the SQL server are also started. If the computer is to be set up for server operation, the browser and the agent must be started in addition to the SQL instance.

Ensure that the following services are started and are automatically started by Windows when the system is started (Computer Management -> Services). Alternatively, you can access service management by selecting "services.msc" start.

  1. SQL Server (INSTANZNAME)
  2. SQL Server Browser

Customise the GpSQL.ini on the clients

The GpSQL.ini must be adapted on the clients. There should only be one GpSQL.ini in the entire GP Manager folder. This means that this file should not be located in the folders of the individual workstations. The correct location is: C:\GeBioM_SQL\GpSystem\INI\GpSQL.ini resp. C:\GPM_V7\GpSystem\INI\GpSQL.ini

  1. Customise the entry T_Server = (local)\GEBIOM in such a way that you (local) through the Server namesor the IP address of the server.
    T_Server = SERVERNAME\GEBIOM
  2. Make sure that T_User = sa is set.
  3. The value T_PASSWD = GeBioM2012 must be set

Setting the data path

The data paths on the clients must be adapted so that the clients store the measurement data on the server and also search for the measurement data there. To do this, create a Sys.ini file with the following content in the GpSystem\INI folder:

[SYS]
PATH_DATA = \\SERVERNAME\GEBIOM_SQL\GpData

or for version 7

[SYS]
PATH_DATA = \\SERVERNAME\GPM_V7\GpData

Make sure that you are using the correct share name and restart the GP Manager.