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
New to ADSelfService Plus?
Related Articles
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 ...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: ...How to change Base currency in MSP
By default, once you set Base currency under SSP, and as long as you create a new PO the base currency is editable under SSP, as well as under Currency. Once you create a new PO, then the base currency is not editable from UI. The same can be ...How to connect to the ServiceDesk database?
For MSSQL database 1. To know the database server information, open command prompt on the server, change the directory to <sdp_home>\bin and invoke the batch file changeDBServer.bat (or changeDBServer.sh) to see the database server information. Note ...