# Setup connection with MSSQL (integratedSecurity) - tables in "Database Query Browser"

**URL:** <https://forum.inductiveautomation.com/t/setup-connection-with-mssql-integratedsecurity-tables-in-database-query-browser/98518>\
**Category:** Ignition\
**Tags:** database\
**Created:** [November 12, 2024, 4:15pm UTC](https://forum.inductiveautomation.com/t/setup-connection-with-mssql-integratedsecurity-tables-in-database-query-browser/98518 "2024-11-12T16:15:26Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Miroslav\_Frisnic](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@Miroslav\_Frisnic](https://forum.inductiveautomation.com/u/Miroslav_Frisnic)\
**Post date:** [November 12, 2024, 4:15pm UTC](https://forum.inductiveautomation.com/t/setup-connection-with-mssql-integratedsecurity-tables-in-database-query-browser/98518/1 "2024-11-12T16:15:26Z")

</div>

hi, please, why there is not viewed table of database in "Database Query Browser"?

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/3/7384ebc2a93a4286fa1f9a6ab551716c903ef5c2.png)

---

<div class="post-metadata">

**Author:** ![YF129701](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/yf129701/32/60498_2.png) [@YF129701](https://forum.inductiveautomation.com/u/YF129701)\
**Post date:** [November 12, 2024, 4:17pm UTC](https://forum.inductiveautomation.com/t/setup-connection-with-mssql-integratedsecurity-tables-in-database-query-browser/98518/2 "2024-11-12T16:17:15Z")

</div>

Did you add the TutorialDB to the Ignition gateway? If so, did you make sure to select it in the dropdown of the Database Query Browser?

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/d/dd72a7d67148b3cfc8034f9439b19bf6e99db64b.png)

---

<div class="post-metadata">

**Author:** ![Benjamin\_Furlani](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/benjamin_furlani/32/66084_2.png) [@Benjamin\_Furlani](https://forum.inductiveautomation.com/u/Benjamin_Furlani)\
**Post date:** [November 12, 2024, 4:20pm UTC](https://forum.inductiveautomation.com/t/setup-connection-with-mssql-integratedsecurity-tables-in-database-query-browser/98518/3 "2024-11-12T16:20:09Z")

</div>

You have master setup as the connections database. You will need to use the other database in the actual connection settings to get the tables from that database

---

<div class="post-metadata">

**Author:** ![Miroslav\_Frisnic](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@Miroslav\_Frisnic](https://forum.inductiveautomation.com/u/Miroslav_Frisnic)\
**Post date:** [November 12, 2024, 4:44pm UTC](https://forum.inductiveautomation.com/t/setup-connection-with-mssql-integratedsecurity-tables-in-database-query-browser/98518/4 "2024-11-12T16:44:22Z")

</div>

... If I setup database in Gateway, connection get failed

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/e/4e4d6529754bc83c998a88cfa74a609e4d8888fe.jpeg)

---

<div class="post-metadata">

**Author:** ![flexware](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/flexware/32/66243_2.png) [@flexware](https://forum.inductiveautomation.com/u/flexware)\
**Post date:** [November 12, 2024, 4:50pm UTC](https://forum.inductiveautomation.com/t/setup-connection-with-mssql-integratedsecurity-tables-in-database-query-browser/98518/5 "2024-11-12T16:50:42Z")

</div>

One problem you may have is that `integratedSecurity=true`, meaning the username and password you specify aren't actually being used AND SQL Server is trying to use AD or some other method to authenticate.

To test, I would remove everything besides `database=TutorialDB` and test it out again. Also, obviously make sure the SQL Server service is running and that TCP/IP is enabled.

[Here is a tutorial](https://docs.inductiveautomation.com/docs/8.1/platform/database-connections/connecting-to-databases/connecting-to-microsoft-sql-server-express#jdbc-drivers-and-translators) to follow along with.

---

<div class="post-metadata">

**Author:** ![Miroslav\_Frisnic](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@Miroslav\_Frisnic](https://forum.inductiveautomation.com/u/Miroslav_Frisnic)\
**Post date:** [November 13, 2024, 7:54am UTC](https://forum.inductiveautomation.com/t/setup-connection-with-mssql-integratedsecurity-tables-in-database-query-browser/98518/6 "2024-11-13T07:54:55Z")

</div>

yes ....as you said _integratedSecurity=true_ was a problem, thank you