How to reset the built-in "admin" account password ?

It is possible to reset the admin password with the help of DB queries.

Microsoft SQL server:

1. Open SQL Server Management Studio. (If it is not installed, it can be downloaded from Microsoft SQL Server Management Studio Express for 32-bit or 64-bit systems. 
2. Login as the database owner or any account which has rights to write on the database and open a new query window.
3. Execute the below mentioned query, Make sure the client management database is selected at the top. 

 

Update Administrators set Authentication=NULL, Password=NULL, SystemPasswordCheck=NULL where LoginName='admin';

In case, using sa to log in SQL Server Management Studio and facing error “Invalid object name 'Administrators'”, execute the below mentioned query which consists of Schema Name. Default Schema is bcmdbuser.

Update bcmdbuser.Administrators set Authentication=NULL, Password=NULL, SystemPasswordCheck=NULL where LoginName='admin';

4. Login to the console with username 'admin' and a blank password.
5. On login to the console, It will prompt with a dialog box to set the new password for 'admin' account.

For Oracle or Postgres database, use the management utilities provided with the database system to run the same query noted above.

• For Oracle databases, the above query can be run using SQLPlus.
• For Postgres databases, the above query can be run using psql utility or pgadmin

Important:

• BMC Client Management version 25.1 cannot be installed on Oracle as the platform will be deprecated in the next release.
• Existing customers currently using Oracle can upgrade to version 25.1, but this will be the final version that supports Oracle
• A migration tool is included with version 25.1 to assist customers in transitioning from Oracle to either SQL Server or PostgreSQL.