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
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 ...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 ...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 ...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. ...How to Connect to SCP Database ? (from 11000 builds)
In-Built POSTGRES (PGSQL) : Open a CMD prompt as an administrator and navigate to ManageEngine\supportcenterplus\pgsql\bin and run the below command 1. If the database is PGSQL (Default database) psql -h localhost -U scpadmin -p 65432 -d ...