# How to connect dremio or datalake to microsoft sql server management studio

**URL:** https://community.cumulocity.com/t/how-to-connect-dremio-or-datalake-to-microsoft-sql-server-management-studio/5969
**Category:** Forum
**Tags:** cumulocity
**Created:** [April 19, 2023, 1:18pm UTC](https://community.cumulocity.com/t/how-to-connect-dremio-or-datalake-to-microsoft-sql-server-management-studio/5969 "2023-04-19T13:18:03Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![mhassan](https://dub1.discourse-cdn.com/flex005/user_avatar/community.cumulocity.com/mhassan/32/4078_2.png) [@mhassan](https://community.cumulocity.com/u/mhassan)
#### Post date: [April 19, 2023, 1:18pm UTC](https://community.cumulocity.com/t/how-to-connect-dremio-or-datalake-to-microsoft-sql-server-management-studio/5969/1 "2023-04-19T13:18:03Z")

</div>

#### _Product/components used and version/fix level are you on:_

10.14

#### _Detailed explanation of the problem:_

We have datahub setup for our tenant and have the access to the Dremio which is setup in azure datalake, we have another tool from which which we would like to connect the offloaded data datalake.  
But could not able to connect the tool with our Dremio and see very limited account access.

#### _Error messages / **full error** message screenshot / log fileL_

#### _Is your question related to the free trial, or to a production (customer) instance?_

#### _Have you installed all the latest fixes for the products and systems you are using?_

---

<div class="post-metadata">

### Author: ![anon53547040](https://avatars.discourse-cdn.com/v4/letter/a/c77e96/32.png) [@anon53547040](https://community.cumulocity.com/u/anon53547040)
#### Post date: [April 19, 2023, 6:29pm UTC](https://community.cumulocity.com/t/how-to-connect-dremio-or-datalake-to-microsoft-sql-server-management-studio/5969/2 "2023-04-19T18:29:23Z")

</div>

Hello Saif,

Could you provide more information on how you try to connect? You need to install the Dremio ODBC driver for Dremio 19 (the one on Dremio’s website is for later versions and does not work with 19!) and then set up a new ODBC connection.

I’d recommend that you open a support ticket to get access to the matching ODBC driver and further support.

Thanks, Tim

---

<div class="post-metadata">

### Author: ![system](https://dub1.discourse-cdn.com/flex005/user_avatar/community.cumulocity.com/system/32/31990_2.png) [@system](https://community.cumulocity.com/u/system)
#### Post date: [October 16, 2023, 6:30pm UTC](https://community.cumulocity.com/t/how-to-connect-dremio-or-datalake-to-microsoft-sql-server-management-studio/5969/3 "2023-10-16T18:30:15Z")

</div>

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.