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 build 10538 , 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 (less than 10538) , 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?

                    • Related Articles

                    • How to connect to the ServiceDesk database?

                      Open command prompt on the server and change the directory to MangeEngine\ServiceDesk\bin, invoke the batch file 'changeDBServer.bat' For MSSQL database  Connect to the query analyzer of the SQL server and execute the queries. For PostgreSQL database ...
                    • 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 connect to the AssetExplorer database?

                      To find the database connected to your installation, open Command Prompt with elevated permission, navigate to [AE-Home]\bin directory and invoke the batch file 'changeDBServer.bat'. [AE-Home] is Drive:\ManageEngine\AssetExplorer\ directory. ...
                    • Syntax for SDP MSP migration to Linux

                      While migrating to different database you can use backupdataold.bat. Here backup will be in .data format and this can be restored in across DB platform. Note: Backup from taken from a particular build can be restored only on the same build. Example: ...