db input doesn't work on DB connect v2

[mchang_splunk]

I find errors in dbx2.log:

2018-09-11T03:51:06.000-0400 mi_input://DBCollect auto_disable_modular_input_due_to_maximum_failed_retries 6 fw123456

2018-09-07T09:32:24-0400 [CRITICAL] [mi_base.py], line 193: action=modular_input_exited_after_maximum_failed_retries modular_input=mi_input://DBCollect max_retries=6 error=ERROR: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Login failed for user 'E987654'.. 
.... 
Exception: ERROR: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Login failed for user 'E792038'.. 
2018-09-07T09:32:24-0400 [INFO] [mi_base.py], line 196: action=auto_disable_modular_input_due_to_maximum_failed_retries modular_input=mi_input://DBCollect max_retries=6 

Tried to set auto_disable=false in inputs.conf, however, db input still can't work.

[mchang_splunk · Accepted solution]

This is most likely user 'E792038' can not login to the database.
Please check the permission or re-type the password on DB connect identity setting.