How can I connect to MYSQL, PostgreSQL and MSSQL database of ServiceDeskPlus-MSP?

Refer to the instruction given below to connect to the Database : (To know the database used, check the file named databaseinfo under SDP-home/server/default/conf folder)

For MSSQL database,connect to the query analyzer (SQL Browser) and right click the ServiceDesk Plus MSP Database (By Default  – DB name will be servicedesk) -> New Query to execute the queries whichever you want to execute.

For MYSQL database,connect to the database following the below steps and then execute the queries.

Open command prompt on the application server,connect to the folder ManageEngine\ServiceDeskPlus-MSP\mysql\bin> and use the command

mysql.exe -u root -P 33366 servicedesk

For PGSQL database,connect to the database following the below steps and then execute the queries.
Open command prompt on the application server,connect to the folder ManageEngine\ServiceDeskPlus-MSP\pgsql\bin> and use the command

psql.exe -U postgres -p 65432 -d servicedesk

This entry was posted in General.

Need More Help?

Are you looking for a personalized customer support? Submit your question or Call our Toll Free Number to speak with ServiceDesk Plus MSP Expert who can offer a better solution for your requirements.

Submit a Ticket
Email : sdpmsp@manageengine.com
Toll Free : 1-888-720-9500