'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