chgsantos/metabase-azure-sql-server.md

Last active July 30, 2019 18:15

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/chgsantos/bd3150619d69ec17128d67f288c1de72.js"></script>
Save chgsantos/bd3150619d69ec17128d67f288c1de72 to your computer and use it in GitHub Desktop.

Metabase connection to Azure SQL Server

Raw

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

Select an option