When I was connecting do Azure SQL Server with Metabase I was getting a timeout error.
To solve it I connected using the following information:
Param | Value |
---|---|
Server | <database-server>.database.windows.net |
Port | 1433 (REQUIRED!!!) |
Database | <database-name> |
Database instance name | empty |
Database user | <database-user> |
Database password | <database-password> |
Additional JDBC options | encrypt=true; trustServerCertificate=false; hostNameInCertificate=*.database.windows.net; loginTimeout=30 |
SSL Tunnel | no |