After the restart, the databaseSQL.exe is executed. This file is located in the C:\GPM_V7 folder. It often happens that the computer installs Windows updates. In this case, the computer may restart several times. In some cases, this results in the DatbenbankSQL.exe file not being executed.

In addition, the file is only saved for the current user. Therefore, after restarting, log in with the same user you used to start the setup.

Troubleshooting

• Open the folder C:\GPM_V7\ and run the exe again.
• Check whether the folder .\GpData\ one ldf and a GpBank.mdf file.
• If the two files are missing, you can download the files from the .\GpTools\Database_empty_for_Express2014\ to .\GpData
• Make sure that GpBank.ldf and GpBank.mdf are also mounted in the instance. To do this, execute the following command (you may need to adjust the path details).
  Start a command prompt as administrator. Press the Windows key and enter them "cmd" in the menu. Then right-click on "Command prompt" and select "Run as administrator" from.
  Enter the following at the prompt:

   sqlcmd -E -S (local)\GEBIOMV7

  You should now have connected to the SQL instance. You can recognise this by the fact that "1 >"
  Enter the following lines. After each line, confirm the entry with Enter. You may need to adjust the paths in the first line.

   exec sp_attach_db'GpBank','C:\GPM_V7\GpData\GpBank.mdf','C:\GPM_V7\GpData\GpBank.ldf'
   go
   exit

• The database is now integrated and the GP Manager is functional.

Microsoft SQL Server Express depends on various Windows updates. If Windows updates are missing, the installation will fail. In addition, to create the actual database (C:\GPM_V7\GpData\GpBank.mdf and C:\GPM_V7\GpData\GpBank.ldf), the system must be restarted (see point 8).

Troubleshooting

• You can recognise whether the Microsoft SQL Server has been installed by checking the status of the service.
• Select "Start" -> "Computer" -> right-click -> "Manage" -> "Services and applications" -> Services
• The SQL Server service is called "SQL Server (GEBIOMV7)". The service should have the status "Started".
• If you cannot find the service, the installation of Microsoft SQL Server has failed. In this case, you can install the SQL Server manually.
• If the service is not started, right-click on the service -> "Properties" -> "Start"

Manual SQL Server installation

To install SQL Server Express manually, it is advisable to select the latest possible version of SQL Server. The latest versions of SQL Server Express can be downloaded from the https://www.microsoft.com/de-de/server-cloud/products/sql-server-editions/sql-server-express.aspx can be downloaded.

Alternatively, a SQL Server Express version is included in the GpTools folder.

Execute the setup and select "Installation" the point "New SQL Server stand-alone installation or add features to an existing installation".

Select a new installation of the SQL Server and click on "Next"

Accept in the next dialogue the licence conditions and select "Next". In the following dialogue you can choose what you want to install. Make sure that "Database Engine Services" and "SQL Server Replication" is selected. The paths can be left at the default values. Then click on "Next"

In the next dialogue, select the option "Named instance". For the GP Manager V6.5 is the default name GEBIOMthe GP Manager V7 should be GEBIOMV7 must be specified. If you specify a different value here, you must enter the GpSQL.ini customise.

In the next dialogue, you can specify how the services should be started. Select "Automatic" and drive them with "Next" continued.

In the next point, you must select the option "Mixed Mode (SQL Server authentication and Windows authentication)" button. Enter the following password GeBioM2012 in the password field. If you choose a different password, you must enter the GpSQL.ini customise.

Also make sure that all users who are authorised to use the database are included in the list of administrators. This is useful, for example, if a backup programme is running under a different user and needs to back up the database. If the user is not listed here, the error message appears when the database is unloaded:

Message '916', level '14', status '1', server 'USERNAME\GEBIOM', line 1
 The server headmaster 'DOMÄNENNAME\BENUTZERNAME' cannot access the GpBank database under the current
 cannot access the GpBank database under the current security context.

This completes the setup of the SQL Server. However, you still need to assign a database to the database instance (see point 9).

The Microsoft Visual Studio Redistributable packages depend on Windows updates. If the corresponding Windows updates have not been installed, the installation will fail at this point.

The Visual Studio Redistributable packages also require administrator rights for installation. If there are no administrator rights for the computer, the setup cannot continue.

You can use "Start" -> "System control" -> "Programmes and functions" to check whether all Visual Studio Redistributable packages have been installed.

If the Visual Studio Redistributable packages are missing, the GP Manger will usually not start.

Troubleshooting

• Try to install the Visual Studio Redistributable packages manually.
• The Visual Studio Redistributable packages are located in the .\GpTools\Vcredist_* folders. You can execute the individual setup files from these folders manually.

   GpTools\Vcredist_2008_SP1\vcredist_x86.exe
   GpTools\Vcredist_2010\vcredist_x86.exe
   GpTools\Vcredist_2012\vcredist_x86_110.exe
   GpTools\Vcredist_2013\vcredist_x86.exe
   GpTools\Vcredist_2015\vcredist_x86_2015.exe

• On the page https://support.microsoft.com/de-de/kb/2977003 you can always download the latest packages.

See point 2.2