How to Reset the Built-In TDM Administrator Password Back to its Default

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

When first installing Datamaker, the default username is 'administrator' and default password is 'marmite'.

If the password is no longer valid, the password will need to be reset.

Environment

Test Data Manager
TDM

Resolution

The password will need to be reset in the GTREP database.


For SQL and Oracle, run the query:

update gtrep_security_user
set su_password = 'BPFj/zB08n3Br/45maAIzI+Ch8vk39RRrzi8PPYJM6ps'
where su_name = 'Administrator';

commit;

 

Additional Information

If this does not work, verify you are connecting to the correct database server and database name for the TDM Portal.
This can be verified in the application.properties file.
The default location is:
C:\Program Files\CA\CA Test Data Manager Portal\conf\application.properties

# Database
spring.datasource.url=jdbc:sqlserver://<hostname>.example.net:1433;database=<database_name>
spring.datasource.username=<username>
spring.datasource.password={cry}<encrypted_password>