How to Connect to SCP Database ? (from 11000 builds)

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?

      Start your free trial

        Resources

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

            • SCP 11.0 - PPM update

              This document is applicable only for the 8.1 to 11.0 upgrades. Please go through this article completely , before proceeding for the upgrade - As this release is a complete redesign of the application, it is mandatory to do the upgrade only in a test ...

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

            • Migration of SCP from one server to another

              1. Stop the application on the production server. 2. Take a trimmed backup of the application (backup without attachments) if you are using the default PgSQL database. If you are using MSSQL, you can take a SQL backup (.bak). 3. Download and install ...

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