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
Enter password scp@123 if prompted.(Default Password)
For linux -> ./psql -h 127.0.0.1 -U scpadmin supportcenter -p 65432
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 ...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 ...Steps to Import accounts / contacts through schedule csv from SCP 11001 build
This is applicable only from 11001 builds. How to do? # Based on the Globalconfig table entry with category as 'CSVUserImportSchedule', this can be turned ON/OFF. By default this is turned OFF. Query to enable the feature - update Globalconfig set ...