Hi Team,
I was able to setup astro with airflow version “Astronomer Runtime 5.0.6 based on Airflow 2.3.3+astro.1” after going through astronomer tutorials and basically wanted to fetch data from MS SQL Server 2019 but in Airflow Connection ,I am getting the following error after giving the correct hostname and port name: “(20009, b’DB-Lib error message 20009, severity 9:\nUnable to connect: Adaptive Server is unavailable or does not exist (5e65e6546565r)\n’)”. I have attached the screenshot of the airflow connection properties which i am setting from UI. Please help me why i am getting this error since my hostname is correct and the port name too. I am using SQL Server windows authentication.
Here is the error screenshot -
