Failed to connect to Azure MySql database

[eddietang]

I can successfully connect to mysql database in mysql workbench, however, when I using the "MySQL Enterprise Edition" connector, I found following issue:

ERROR [08001] [Qlik][MySQL] (1004) The connection has timed out while connecting to server: demosrv.mysql.database.azure.com at port: 3306.

Any advise to resolve the problem. Thanks.

[Sebastian_Linser · Accepted solution]

Hello @eddietang ,

is the mysql workbench also installed on your Qlik Sense Server? Otherwise it might be the need to whitelist a second IP for access to the database.  https://docs.microsoft.com/en-us/azure/mysql/single-server/how-to-manage-firewall-using-portal

best regards

Sebastian

[eddietang]

Problem solved after adding the whitelist for the qlikcloud. Thanks.