So we are transitioning from Azure Sql DB to Azure Synapse Sql Pools. I figured this was a simple redirection of login since that’s all it took when connecting via mssql server, but Airflow keeps throwing this error:
(40532, b’Cannot open server “1433” requested by the login. The login failed.
I have reentered the credentials and tested the credentials in mssql server so I’m pretty sure its not a username/password issue, and the connection string Synapse shows 1433 is the correct port. Anyone have any advice on what might be happening? We use the generic MssqlOperator and Mssqlhook.
hi, try using
airflow.providers.odbc.hooks.odbc