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