Contents

Overview

QESTNet is configured to connect to one or more database to perform various tasks. These connections include the QEST Platform database, Construction Hive Publishing database and Custom Integration databases.

Types of Database Connections

QEST Platform Database Connection

This connection is used throughout the QEST Platform to connect to the main QEST Platform database and is required.

Open

Construction Hive Publishing Database Connection

This connection is used to allow QESTField products to publish reports and forms to Construction Hive.

Open

Custom Integrator Database Connections

These connections are used by Custom Data Integrators for integration between the QEST Platform and third party applications.

Open

Database Connection Settings

The following properties can be set for each connection:

• Server: the name of the SQL server instance where the database exists.

• Database Name: the name of the QEST Platform database.

• Use Windows Authentication: QESTNet will use windows authentication to access the database if this option is checked. This will be true by default and will require that the service user running the QESTNet service has been granted db_owner rights on the database in question. For more details regarding granting database access rights for QESTNet please see Granting Access to QEST Platform Databases.

• User ID: Only applicable if the Use Windows Authentication checkbox is not checked. The user id to use when logging into the database using SQL Authentication.

• Password: Only applicable if the Use Windows Authentication checkbox is not checked. The password to use when logging into the database using SQL Authentication.

Testing the Database Connections

Beneath each of the Database Connections is a button that will test the connection. This is a very simple test that purely attempts to log onto the database. 

Open

If a test results in a failure, a reason for the failure will be displayed. The most likely reasons are that the Server or Database Name are incorrect or that the QESTNet service user does not have permission to access the database and Windows Authentication is being used.

Open