Configuring Remote Access to the Database in Endpoint Central

Endpoint Central stores all the information in a database. For example, it comprises information pertaining to IT assets such as hardware and software details, configuration details, etc.

You can access this database remotely to get certain information. For example, assume that you require information from the database to help you to generate specific reports that are not readily available and cannot be generated using the Custom Reports feature. In such cases, one can access the database used by the product server to get this information.

The database located in Endpoint Central server can be accessed remotely. However, not everyone has permission to access the database. Only administrators can grant/revoke access to computers to connect to the database remotely.

When you grant permission, the user will have Read-Only access to the database.

Granting access

This section is applicable only to administrators.

To grant remote access to the database, follow the steps given below:

1. Navigate to the Admin tab.

2. Under Database Settings, click on Remote DB Access.

3. Select Grant Access and enter the Remote Computer name to which you want to grant access.

   Note: Once this settings is configured, restart the Endpoint Central service - ManageEngine UEMS Server to apply the settings.

When you grant access, it is highly recommended that you check the usage status periodically and revoke the access to the database from users who:

1. Are not required to access the database

2. Have access to the database but are not using it

If the computer, from which a user is accessing the database remotely, is in a domain that is different from that of the database, specify the computer name along with its DNS suffix. For example, john.desktopcentral.com

You have granted remote access to the database in Endpoint Central server.

To revoke access to the database, follow the steps given below:

1. Navigate to the Admin tab.

2. Under Database Settings, click on Remote DB Access.

3. The list of computers that have been granted access would be displayed. Under Actions column , select Revoke Access to revoke the access granted to that particular computer.

You have revoked remote access to the database in Endpoint Central server.

Connecting remotely to the database

You can use any JDBC tool like PGadmin to connect remotely to the database in the Endpoint Central server. Ensure that the computer from which you are trying to establish a remote connection has been granted access before you try connecting to the database.

Checking for computers with access

To view the list of the computers which have been granted access, follow the steps given below:

1. Navigate to the Admin tab

2. Under Database Settings, click on Remote DB Access

3. You can now see the list of computers that have been granted access.

Details required to connect remotely

You require the following details to connect remotely to the database in the Endpoint Central server:

• PGSQL Host Address: The host address will be the same as that of the computer where the Endpoint Central server is installed and running.
• Username: This refers to the username that you are required to enter for connecting remotely to the database. The username for connecting to the PGSQL database is medc.
• Please create a strong password of your choice to access the remote DB. This default password needs to be changed before granting or revoking access for computer(s).
• Port for  : This refers to the port number that is required to connect to the database.
• PGSQL port details - This refers to the port number that is required to connect to the database. By default, the port number is 8028.
• Database(s): This refers to the name of the database that you want to connect to remotely. You should enter desktopcentral in this field.