# Not able to connect azure sql server from Dremio **URL:** \ **Category:** Uncategorized\ **Created:** [September 28, 2021, 8:05am UTC](https://community.dremio.com/t/not-able-to-connect-azure-sql-server-from-dremio/8045 "2021-09-28T08:05:36Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![sunil\_patra](https://avatars.discourse-cdn.com/v4/letter/s/b38774/32.png) [@sunil\_patra](https://community.dremio.com/u/sunil_patra)\ **Post date:** [September 28, 2021, 8:05am UTC](https://community.dremio.com/t/not-able-to-connect-azure-sql-server-from-dremio/8045/1 "2021-09-28T08:05:37Z")
Hi Team, We are not able add azure sql server as external datasource in dremio. We have opened all the firewall access (azure sqlserver end) to connect to azure sql server but its throwing error and not able to connect from dremio. Please help . Let us know if we need to open in firewall from dremio server end to connect to azure sql server. Thanks, Sunil ---
**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\ **Post date:** [September 29, 2021, 7:10am UTC](https://community.dremio.com/t/not-able-to-connect-azure-sql-server-from-dremio/8045/2 "2021-09-29T07:10:21Z")
@sunil_patra Are you able to provide the server.log from the coordinator? It will tell us why you are unable to connect. Dremio only supports MS-SQL so it could be possible some packages it uses to get SQL server metadata may not be present on Azure SQL ---
**Author:** ![sunil\_patra](https://avatars.discourse-cdn.com/v4/letter/s/b38774/32.png) [@sunil\_patra](https://community.dremio.com/u/sunil_patra)\ **Post date:** [January 7, 2022, 9:31am UTC](https://community.dremio.com/t/not-able-to-connect-azure-sql-server-from-dremio/8045/3 "2022-01-07T09:31:59Z")
Thank you Balaji . We got this issue resolved after opening the firewall for Dremio → Azure SQL DB.