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)
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