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 ...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 ...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 ( ...How to connect to Database in Version 11.0? PGSQL
1.Open a cmd with admin privileges 2.navigate to ManageEngine\SupportCenterPlus\pgsql\bin and enter the below command: psql.exe -U scpadmin -p 65432 -h 127.0.0.1 supportcenter For example: SupportCenterPlus\pgsql\bin>psql.exe -U scpadmin -p 65432 -h ...