# FactoryPMI doesn't see SQLTags tables in MSSQL

**URL:** <https://forum.inductiveautomation.com/t/factorypmi-doesnt-see-sqltags-tables-in-mssql/491>\
**Category:** Archived Topics\
**Created:** [January 13, 2008, 10:05pm UTC](https://forum.inductiveautomation.com/t/factorypmi-doesnt-see-sqltags-tables-in-mssql/491 "2008-01-13T22:05:56Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![timf](https://avatars.discourse-cdn.com/v4/letter/t/7cd45c/32.png) [@timf](https://forum.inductiveautomation.com/u/timf)\
**Post date:** [January 13, 2008, 10:05pm UTC](https://forum.inductiveautomation.com/t/factorypmi-doesnt-see-sqltags-tables-in-mssql/491/1 "2008-01-13T22:05:56Z")

</div>

I’m trying to use Microsoft SQL Server and didn’t install MySQL. I created a data connection called MSSQL in FactorySQL. When I go into FactoryPMI Gateway Status in the SQLTags tab, it says SQLTags tables not created. Run FactorySQL to create tables. I did run FactorySQL and there are several tables in the database starting with sqlt\_\*. What else do I need to do?

---

<div class="post-metadata">

**Author:** ![nathan](https://avatars.discourse-cdn.com/v4/letter/n/c5a1d2/32.png) [@nathan](https://forum.inductiveautomation.com/u/nathan)\
**Post date:** [January 14, 2008, 12:15am UTC](https://forum.inductiveautomation.com/t/factorypmi-doesnt-see-sqltags-tables-in-mssql/491/2 "2008-01-14T00:15:32Z")

</div>

There is a SQLTags configuration section in FactorySQL. It’s a matter of checking a checkbox to enable SQLTags and selecting a datasource (your SQL Server connection). You may need to restart the FSQL service after doing this (or reboot).

---

<div class="post-metadata">

**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\
**Post date:** [January 14, 2008, 12:51am UTC](https://forum.inductiveautomation.com/t/factorypmi-doesnt-see-sqltags-tables-in-mssql/491/3 "2008-01-14T00:51:00Z")

</div>

He said in his post that he sees several tables named sqlt\_\*. Every time I’ve seen someone have a problem with this, it’s simply been that the 2 data connections (FactorySQL & FactoryPMI) aren’t exactly the same, usually pointing to different database names.

Double check that you’re going to the same server, and to the same database. If that’s absolutely correct, we can go from there.

Regards,

---

<div class="post-metadata">

**Author:** ![timf](https://avatars.discourse-cdn.com/v4/letter/t/7cd45c/32.png) [@timf](https://forum.inductiveautomation.com/u/timf)\
**Post date:** [January 14, 2008, 3:26pm UTC](https://forum.inductiveautomation.com/t/factorypmi-doesnt-see-sqltags-tables-in-mssql/491/4 "2008-01-14T15:26:07Z")

</div>

The problem was that I wasn’t paying attention to the JDBC Connect URL in the Gateway configuration. This has to be configured correctly for the Designer to see the tables.
