Hello All,

Recently we have changed SQL DB User id password and same was updated in database.yml and server.xml file (encrypted formatted) . Also I have updated this in database source.

But still Import is getting failed and getting error as below

(+0:00:00.062) INFO: Data Source: MSSQL database collation: SQL_Latin1_General_CP1_CI_AS.

2021-03-18 04:00:03 (+0:00:00.078) ERROR: Database connection error: Java::ComMicrosoftSqlserverJdbc::SQLServerException: Login failed for user 'ILMT'. ClientConnectionId:b3c9fd20-19bd-409c-817e-8376215fd447

2021-03-18 04:00:03 (+0:00:00.000) ERROR: RECOMMENDED USER ACTION: Invalid login or password. Check your user and password if they are correct or if the password is not expired.

2021-03-18 04:00:03 (+0:00:00.047) INFO: Initialize datasource Data Source: Failed

2021-03-18 04:00:03

Please suggest!!

Regards,

Manish Singh

Hello,

Is this DB user used for both ILMT and Bigfix databases ? Have you updated the password in both ILMT and Bigfix, as per:

https://www.ibm.com/docs/en/license-metric-tool?topic=database-updating-password

?

Thanks.