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
Database migration from MySQL to Postgres/MSSQL in SCP 8.1
We no longer support the use of MYSQL as database in SupportCenter Plus. Hence, we request our users to migrate to Postgres (which is in-built) or Microsoft SQL. Please follow the below steps to carry out the database migration: 1. Shutdown the ...Inline images broken after SCP Upgrade
We suspect that this issue may arise if the migration schedule has not been run post-upgrade. To troubleshoot this issue further, we kindly request the output of the following query. Please connect to the database of the working build and execute the ...To connect Postgres database from remote PC using PgAdmin tool
Please follow the below steps to connect Postgres database from remote PC using PgAdmin tool. Stop the server and perform the steps. 1. Go to the location C:\\ManageEngine\\SupportCenter\\pgsql\\data, edit the file postgresql.conf and make the below ...SCP upgrade from 11.0 to 14.0 prerequisites
Before migration to scp version 14 below 2 points has to be done in scp 11027 1. Back up password should not be default i.e SCP123!, it should be updated 2. TLSv1, TLSv1.1 has to be added under the file /home/jre/lib/security/java.security file ( ...SCP 11.0 and Jira integration
Integration Steps In SCP 11.0, JIRA administrator credentials and server URL configuration fields will not be available in the Jira.xml file. They must be configured on the current integration page. Follow the below steps to move the integration ...