# Not all databases listed in SQL Server datasource (only 4)

**URL:** <https://community.dremio.com/t/not-all-databases-listed-in-sql-server-datasource-only-4/1509>\
**Category:** Uncategorized\
**Created:** [July 24, 2018, 8:09am UTC](https://community.dremio.com/t/not-all-databases-listed-in-sql-server-datasource-only-4/1509 "2018-07-24T08:09:00Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![orlandob](https://avatars.discourse-cdn.com/v4/letter/o/f07891/32.png) [@orlandob](https://community.dremio.com/u/orlandob)\
**Post date:** [July 24, 2018, 2:34pm UTC](https://community.dremio.com/t/not-all-databases-listed-in-sql-server-datasource-only-4/1509/6 "2018-07-24T14:34:14Z")

</div>

I also tried from within the Dremio query panel on my ‘Order’ dataset:

SELECT \*  
FROM “Order”.“SCORD”.“Order”.“OrderItem”

I get nicely sampled results, and the database now appears (only with one table OrderItem though).

Very strange behaviour.

![datasource2](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/1X/320ad934791a08fd24a33aa7ee3cd8a801314db5.png)

---

_[View the full topic](https://community.dremio.com/t/not-all-databases-listed-in-sql-server-datasource-only-4/1509)._