Installation of Microsoft SQL Express (for 7.)

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"

Dienste-SQL-Server-Markiert

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".

SQL_Setup_01_markiert

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

SQL_Setup_02_markiert

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"

SQL_Setup_04_markiert

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.

SQL_Setup_05_markiert

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

SQL_Setup_06_1_markiert

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.
SQL_Setup_07_markiert

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