Hello Databricks community,

I am trying to connect to Azure SQL DB from Databricks free edition, however ran into below error-

[FAILED_JDBC.CONNECTION] Failed JDBC on the operation: Failed to connect to the database. SQLSTATE: HV000

I have tried adding the firewall rules by allowing the IPs from different ranges as searched in internet and also gave range from 0.0.0.0 to 255.255.255.255 as well. Enabled Allow Azure services as well, but still getting the same error.

However I am able to access the same Azure SQL DB from local VS code with same credentials.

Can someone help me in resolving this issue and let me know if any specific IPs I need to add under Azure SQL server Firewall rule? Thanks in advance.