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 the server location, port and database name.
2. Connect to SQL Server Management Studio (SSMS) with the database details, right click on the database that you have configured and click on "New Query".
For PostgreSQL database:
1. To know the database server information, open command prompt on the server, change the directory to MangeEngine\ServiceDesk\bin and invoke the changeDBServer.bat (or changeDBServer.sh). Note the port and the database name.
2. To know the password of sdpadmin user, invoke the batch file decryptPostgresPassword.bat (or decryptPostgresPassword.sh) and enter the name sdpadmin
(For environments below SDP version 10.5 the password is sdp@123)
3. Now change the directory to <sdp_home>\pgsql\bin and run the below (change port and database name as required) and enter the password when promted.
psql.exe -U sdpadmin -p 65432 -d servicedesk -h 127.0.0.1
For MySQL database
Open command prompt on the application server and change the directory to ManageEngine\ServiceDesk\mysql\bin>
use the below command to the connect to the database
mysql.exe -u root -P 33366 servicedesk
For older versions:
For environments running version 9.4
(To know the database used, check the file named databaseinfo under [SDP-Home]/conf folder)
For environments running version 9.3 and below
(To know the database used, check the file named databaseinfo under [SDP-Home]/server/default/conf folder)
(To know the database used, check the file named databaseinfo under [SDP-Home]/server/default/conf folder)
New to ADSelfService Plus?
Related Articles
How to change the database from MySQL/PostgreSQL to MSSQL
The steps mentioned below are applicable only if you migrate the DB from PgSQL to MSSQL. This means that the application server is going to remain the same. The data alone is going to be transferred to MSSQL DB from the existing PgSQL DB. For ...How do I convert the database from PGSQL to MSSQL?
1. Stop ManageEngine ServiceDeskPlus – MSP service. 2. Take a backup of the existing data and configuration under PGSQL database by following the below steps. Open CMD as an administrator and execute command to start the data backup. ...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 ...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 PGSQL from a remote computer?
To remotely access a PostgreSQL database, you must set the two main PostgreSQL configuration files: postgresql.conf pg_hba.conf First of all, configure PostgreSQL service to listen on port 65432 on all network interfaces in Windows 7 machine: open ...