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