Configuring Remote Access to the Database in Endpoint Central MSP

Endpoint Central MSP 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 Endpoint Central MSP to get this information.

The database located in Endpoint Central MSP 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 are granted permission you can only read the information that is available in the database.

Granting Access

This section is applicable only to administrators.

 

To grant remote access to the database in Endpoint Central MSP server, 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.

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.endpointcentral.com

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

To revoke access to the database in Endpoint Central MSP server, 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 the product server.

Connecting Remotely to the Database

You can use any JDBC tool like PGadmin to connect remotely to the database in the Endpoint Central MSP 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:

1. PGSQL Host Address: The host address will be the same as that of the computer where the Endpoint Central server is installed and running.

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

Password for PGSQL database : Enter

medc

as the password. This default password needs to be changed before granting or revoking access for computer(s).

 

1. 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 8058.

2. Database(s): This refers to the name of the database that you want to connect to remotely. You should enter desktopcentral in this field.