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)  

                                    
2. MSSQL:

In the MSSQL Server, connect to the SQL studio.

Default Database name: supportcenter

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