Symptoms
Investigation
Data needed for analysis:
The following error message can be found in the Working Processes log file:
SQL_ERROR Database handles DB-HENV: 3d9200 DB-HDBC: 3d92c0
U0003591 DB error info: Opc: 'SQLDriverConnect' Return code: 'ERROR'
U0003592 Status: '28000' Native error: '18456' Msg: 'Login failed for user 'Automic'.'
U0003592 Status: '42000' Native error: '4060' Msg: 'Cannot open database "Automic" requested by the login. The login failed.'
U0003590 DB error: 'SQLDriverConnect', 'ERROR ', '42000', 'CannotThe error message "U0003592 Status: '42000' Native error: '4060' Msg: 'Cannot open database "Automic" requested by the login. The login failed." is returned by the database when Automic tries to logon.
Cause
The password set in the connection string in the UCSRV.ini ODBC section (default location in Automation Engine/bin) is not valid.
Automic receives the error message that the login has failed from the database and no connection to the database is possible.
Resolution