How to Connect to SDP MSP Database ?

How to Connect to SDP MSP Database ?

In-Built POSTGRES (PGSQL) :

Open a CMD prompt as an administrator and navigate to ManageEngine\ServiceDeskPlus-MSP\pgsql\bin and run the below command
                                   
 If MSP versions less than 10.5:
                                                            
psql -h localhost -U postgres -p 65432 -d servicedesk 
Enter password postgres if prompted.(Default Password)  

                                    
If MSP versions greater than 10.5:
                                                            
psql -h localhost -U sdpadmin -p 65432 -d servicedesk
Enter password sdp@123 when prompted.(Default Password)      

2. MSSQL:

In the MSSQL Server, connect to the SQL studio.
          • Related Articles

          • Database Schema of MSP

            The database schema is accessible from within the ServiceDesk Plus MSP application. Navigate to Reports -> New Query report -> Here you can click on the two icons available to view the Schema like shown below, For more details on the important table ...
          • SCP, SDP and MSP Differences

            Though ManageEngine has multiple HelpDesk applications, they are developed and targeted for Different markets. Here are few cases to understand the difference between them. HelpDesk Applications in ManageEngine (ME) are as follows :  1. SupportCenter ...
          • SDP - SDP MSP Integration using Custom Triggers

            This article helps users to integrate ManageEngine ServiceDesk Plus (SDP) - ServiceDesk Plus MSP (SDP MSP) using Custom triggers and Custom Schedules feature.  This is compatible with SDP Build - 11113 and SDP MSP Build - 10507 This will help the MSP ...
          • Connect to default PGSQL database remotely

            1. To be able to reach the server remotely you have to add the following line into the file: ManageEngine/ServiceDeskPlus-MSP/pgsql/data/postgresql.conf:   listen_addresses = '*'   2. PostgreSQL, by default, refuses all connections it receives from ...
          • Remote read only access to database for Postgres customers

            Use case: Frequently customers want to connect some reporting / dashboard application like PowerBI or Tableau with our Postgres database server. By default, the bundled Postgres is configured to only listen to the local machine. We can configure to ...