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
If you are using SQL server as backend DB , then connect to the SQL studio.
Default Database name is - ServiceDesk