HPDM - How to change database credentials

[Daniel651]

Hello,

I want to change the database credentials that the system uses to log into the SQL db. The old credentials don't exist anymore.

How can I change those credentials?

I tried editing the hibernate.properties file but that doesn't work.

When I open the configuration editor I see the username:

But when I click Manage Database, I get an error that the login has failed - Note - I have confirmed the DB login works.

This is what I see in hpdm-dbsetup log file:

2021-08-27 10:07:13 [WT-EventQueue-0] DEBUG DBSetupWizardPanel - doPageChanging: SelectionPage >> UseExistDB
2021-08-27 10:07:18 [WT-EventQueue-0] INFO DBObject - Database setup failed.
2021-08-27 10:21:25 [main ] INFO MainApplication - HP Device Manager Database Setup Application Version: 5.0.3610.38748
2021-08-27 10:21:32 [Thread-0] INFO DBSetupUtil - ..\conf\windows_auth.conf (The system cannot find the file specified)
2021-08-27 10:21:32 [Thread-0] INFO HibernateDBObject - Preparing Hibernate properties.
2021-08-27 10:21:32 [Thread-0] DEBUG DBObject - db = com.hp.hpdm.dbsetup.dao.HibernateDBObject@70a0d9a8
2021-08-27 10:21:32 [Thread-0] DEBUG DBObject - db.conn = null
2021-08-27 10:21:33 [Thread-0] WARN HibernateDBObject - com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "hpdmdbsep5" requested by the login. The login failed. ClientConnectionId:81006b18-09d4-40ab-b491-6323cc7ff3c5
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)
com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:251)
com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:81)
com.microsoft.sqlserver.jdbc.SQLServerConnection$1LogonProcessor.complete(SQLServerConnection.java:2826)
com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:3082)
com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2361)
com.microsoft.sqlserver.jdbc.SQLServerConnection.access$100(SQLServerConnection.java:44)
com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2347)
com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:6276)
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1794)
com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1405)
com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1069)
com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:905)
com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:452)
com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1014)
java.sql/java.sql.DriverManager.getConnection(Unknown Source)
java.sql/java.sql.DriverManager.getConnection(Unknown Source)
com.hp.hpdm.dbsetup.dao.DBObject.getConnection(DBObject.java:171)
com.hp.hpdm.dbsetup.util.DBSetupUtil.upgradeDB_all(DBSetupUtil.java:682)
com.hp.hpdm.dbsetup.util.DBSetupUtil.upgradeDBAutomatic(DBSetupUtil.java:927)
com.hp.hpdm.dbsetup.handler.PageChangingListener$5.go(PageChangingListener.java:405)
com.hp.hpdm.dbsetup.util.ProgressDialog$3.run(ProgressDialog.java:126)
java.base/java.lang.Thread.run(Unknown Source)

2021-08-27 10:22:33 [Thread-0] WARN DBSetupUtil - Get DB Connection fail.
2021-08-27 10:22:34 [WT-EventQueue-0] DEBUG DBSetupWizardPanel - doPageChanging: SelectionPage >> UseExistDB
2021-08-27 10:22:36 [WT-EventQueue-0] INFO DBObject - Database setup failed.