# Dremio connecting to MS SQL Server

**URL:** <https://community.dremio.com/t/dremio-connecting-to-ms-sql-server/10904>\
**Category:** Uncategorized\
**Created:** [August 19, 2023, 3:55pm UTC](https://community.dremio.com/t/dremio-connecting-to-ms-sql-server/10904 "2023-08-19T15:55:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Yosi](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/yosi/32/5090_2.png) [@Yosi](https://community.dremio.com/u/Yosi)\
**Post date:** [August 19, 2023, 3:55pm UTC](https://community.dremio.com/t/dremio-connecting-to-ms-sql-server/10904/1 "2023-08-19T15:55:18Z")

</div>

Greetings

Have looked high and low for this I am raising the white flag. I have spun up dreamio using  
`dockerrun -p 9047:9047 -p 31010:31010 -p 45678:45678 dremio/dremio-oss -v ./data:/opt/dremio/data`

And now I want to connect to my local SQL server installed on my laptop. Do I need to install some sort of driver within this dremio container for it to connect to my sql server?

I am getting the following error

Could not connect to mssql, check your JDBC connection information and credentials.

Thanks!

---

<div class="post-metadata">

**Author:** ![Yosi](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/yosi/32/5090_2.png) [@Yosi](https://community.dremio.com/u/Yosi)\
**Post date:** [August 19, 2023, 4:23pm UTC](https://community.dremio.com/t/dremio-connecting-to-ms-sql-server/10904/2 "2023-08-19T16:23:07Z")

</div>

Had to use the ip address used for tcp/ip!

Thanks

---

<div class="post-metadata">

**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:** [August 22, 2023, 3:50am UTC](https://community.dremio.com/t/dremio-connecting-to-ms-sql-server/10904/3 "2023-08-22T03:50:52Z")

</div>

@Yosi Glad you were able to resolve the issue, kindly let us know if you have any other questions
