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

Product/components used and version/fix level are you on:


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?

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

1 Like

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