I am trying to connect to Azure SQL database on PAAS environment. This is required to write data from Databricks to azure SQL database and also read data from Azure SQL database.
When i run the connection string and try to connect to a table present in SQL database using datbricks get the below error message. Do i need to open ports on SQL server database side and also how databricks can read data from SQL database. Are their any reference articles.
Error message : SQL server Exception : The TCP/IP connection to the host port has failed. Verify the connection properties.. Make sure that the instance of SQL server is running on the host and accepting TCP/IP connnectionss at the port . Make sure that the TCP connecstions to the port are not blocked by a firewall.