How to connect to the ServiceDesk database?
Open command prompt on the server and change the directory to MangeEngine\ServiceDesk\bin, invoke the batch file 'changeDBServer.bat'
For MSSQL database
Connect to the query analyzer of the SQL server and execute the queries.
For PostgreSQL database
Open command prompt on the application server and change the directory to ManageEngine\ServiceDesk\pgsql\bin>
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)
Open command prompt on the application server,connect to the folder ManageEngine\ServiceDesk\pgsql\bin> psql.exe -U postgres -p 65432 -d servicedesk -h 127.0.0.1
For environments running version 10.5 and above
Open command prompt on the application server, connect to the folder ManageEngine\ServiceDesk\pgsql\bin> psql.exe -U sdpadmin -p 65432 -d servicedesk -h 127.0.0.1
when prompted for password enter sdp@123 and connect to the database.
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
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 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 ...How to change the database from MSSQL to PostgreSQL
The steps mentioned below are applicable only if you migrate the DB from MSSQL to PgSQL. This means that the application server is going to remain the same. The data alone is going to be transferred to PgSQL DB from the existing MSSL DB. For ...How to find the MSSQL Lock on the database directly?
Connect to the MSSQL database and open the query editor for service desk database(any database should work) 1. Execute the query sp_who2 2. Above command will show the list of database query process which is currently in execution that causes the ...