8.1 Reset global admin Password from the database

8.1 Reset global admin Password from the database

For SupportCenter Plus 8.1 and below:

Follow the below steps to reset a global admin password from the database (only if you don't have another Global Administrator account to login and reset the password from the user interface):

1. Connect to the DB, and execute the below select query to find the Global Admin users:

    select au.user_id "User ID", al.login_id"Login ID",au.first_name"Name",al.name"Login Name" from GlobalAdmin ga Left join sduser sd on ga.SUPPORTREPID=sd.USERID left join aaauser au on sd.userid=au.user_id left join aaalogin al on au.user_id=al.user_id where sd.status='ACTIVE';

The above query would list the global admin users like below:

2. Now, in order to reset the password for the available user, the user ID that was retrieved from the above query should be replaced in the below query:

    update AaaPassword set password='2+uYvE3SLfO3XaHl+CaGLA==', SALT='1103287238602' where password_id in (select ap.password_id from aaaaccpassword ap left join aaaaccount ac on ac.account_id=ap.account_id left join aaalogin al on al.login_id=ac.login_id where al.user_id=user ID);

Like below:

Once you run the query, the password will be updated. The default password for the user will be admin

3. Restart the application and login as the user with the password as admin.

To connect to Postgres DB, please refer to this link.

For MS-SQL, please execute the query in SQL Studio under SuppportCenter Database.

          • Related Articles

          • How to reset Admin password (SDOrg) for SupportCenter Plus 11.0 and above

            1. Access your SupportCenter Plus server and browse to [your drive]:\ManageEngine\SupportCenterPlus\bin. 2. Click changeDBServer.bat. Information on the configured database will be displayed.   If the database is MSSQL, go to the SQL Management ...
          • 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 ...
          • 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 supportcenter For example: SupportCenterPlus\pgsql\bin>psql.exe -U scpadmin -p 65432 -h ...
          • 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 ...
          • Database will not start when mysql database is used with SCP

            Check with the wrapper.conf and check the database type specified and change it from pgsql to mysql. i.e look for the line wrapper.java.additional.12=-Ddb.home=../pgsql and change it as wrapper.java.additional.12=-Ddb.home=../mysql.