'Airflow Pymssql connection
I have an Airflow server and want to declare a connection to my local SQL Server database. These is the code I used with pymssql:
conn = pymssql.connect(
host='localhost',
server="localhost\SQLEXPRESS",
port=1433,
user="sa",
password="demo",
database="Test")
This works, but what should be the settings in the connection in Airflow?Connection screen
The current settings gives me a 20009 error.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
