How to Connect to SDP MSP Database ?

How to Connect to SDP MSP Database ?

1. In-Built POSTGRES (PGSQL) :

Open a CMD prompt as an administrator and navigate to ManageEngine\ServiceDeskPlus-MSP\pgsql\bin and run the below command
                                   
From SDP MSP version 10.6 , please use the below method.
                                                            
psql -h localhost -U sdpadmin -p 65432 -d servicedesk
Enter password sdp@123 when prompted.(Default Password)      


From SDP MSP version 10.5 and lesser version , please use the below method.
                                                            
psql -h localhost -U postgres -p 65432 -d servicedesk 
Enter password postgres if prompted.(Default Password)  
                                    
If you are facing the below error, please click here for solution.

psql: FATAL: no pg_hba.conf entry for host “::1”, user “postgres”, database “servicedesk”,SSL off

2. MSSQL:

If you are using SQL server as backend DB , then connect to the SQL studio.
Default Database name is - ServiceDesk


      New to ADSelfService Plus?

      Start your free trial

        Resources

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

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

            • How to migrate data from SDP MSP to SDP ?

              Below are the only details which can be exported from SDP MSP and imported to SDP application. 1) You can export request data from ServiceDesk Plus MSP (SDP MSP) using XLS format. Requests -> Goto Admin -> Reports -> New custom report -> Tabular ...

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