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 supportcenter
-> For version till 14610: Enter password scp@123 if prompted.(Default Password)
Password for versions from 14620: Open a command prompt as an administrator -> path to the application folder -> bin , execute the below command.
For Windows: execute decryptPostgresPassword.bat -> for Windows
The password will be displayed there.
For linux -> ./psql -h 127.0.0.1 -U scpadmin supportcenter -p 65432
Password for versions from 14620: Open a command prompt as an administrator -> path to the application folder -> bin , execute the below command.
For Linux: sh decryptPostgresPassword.sh
The password will be displayed there.
2. MSSQL:
In the MSSQL Server, connect to the SQL studio.
Default Database name: supportcenter
New to ADSelfService Plus?
Related Articles
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 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 ...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 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 ...Default Postgres Database password from Builds 14620 and above
For users in ServiceDesk Plus MSP build 14620 and above , the default PostgreSQL database password will now be auto-generated for sdpadmin. For Builds 14620 and above: For security reasons, the default Postgres database password will now be randomly ...