Can't connect to AWS RDS SQL Server

Hi,

I’m trying to connect my Redash self-hosted install to AWS RDS SQL Server. The SQL server allows connections from the Redash host, but I’m getting the below message when testing connection.

DB-Lib error message 20002, severity 9: Adaptive Server connection failed

TDS Version: 7.0, 7.1, 8.0 - none work.

Has anyone come across this problem or share a solution?

Thanks.

I think this is the same issue: Can't connect to Microsoft SQL Server with tds version 7.4

Which is an incompatibility between pymssql (employed by Redash versions 8 and older) and TDS version 7.

Redash V9 uses ODBC to connect and avoids this issue.