Hi there
I want to establish a database connection.
In the Dynamic SQL Tab I wrote the connection string and the test was successful.
But running the workflow there is the message “Error opening Database”
Does anyone knows what could be the problem?
Hello @Christian ,
Can you please share the entire logging of the Workflow plugin by which the error occurs? Please make sure that it doesn’t contain any sensitive information.
A possible scenario in which the error may occur is when the database is locked by an user.
Solution ID 231030105229300
Hello Marten,
The Log:
ERROR: 10:59:38.778 [0002] W3610 : Error opening database: [MySQL][ODBC 8.0(a) Driver]Access denied for user ‘[user]’@‘[IP]’ (using password: YES)
ERROR: 10:59:38.779 [0002] Datenbankabfrage: W1603 : Plugin failed - 10:59:38 (elapsed time: 00:00:00.129)
If the database is locked by an user, would the test be succesful?
This looks to me like a security issue. The user is not authorized to log on to the database. So, either the username/password is wrong or the ip/host where the user is coming from is not authorized.
