CODEWITHSUNDEEP
macosazuredata-warehouseazure-synapse
Joseph Idziorek
Joseph Idziorek

Reputation: 5101

Connect to Azure SQL Data Warehouse from Mac OS X

I'm trying to connect to Azure SQL Data Warehouse from the command line on my MacBook with sql-cli. With the following connection string, the login just hangs ("Connecting to .database.windows.net....") 

$ mssql -s <serverName>.database.windows.net -u <userName>@<serverName> -p <password> -d <dwName>

Does anyone have any ideas?

Upvotes: 2

Views: 728

Answers (1)

Joseph Idziorek
Joseph Idziorek

Reputation: 5101

Azure SQL DW requires an encrypted connection. Using the "-e" in the connection string solves the problem:

$ mssql -s <serverName>.database.windows.net -u <userName>@<serverName> -p <password> -d <dwName> -e

Upvotes: 1

Related Questions