# No tag Historian tables created in database **URL:** \ **Category:** Ignition\ **Created:** [September 22, 2018, 11:50pm UTC](https://forum.inductiveautomation.com/t/no-tag-historian-tables-created-in-database/19781 "2018-09-22T23:50:57Z")\ **Posts on this page:** 6\ **Page:** 2
**Author:** ![kirsten.chambers](https://avatars.discourse-cdn.com/v4/letter/k/48db29/32.png) [@kirsten.chambers](https://forum.inductiveautomation.com/u/kirsten.chambers)\ **Post date:** [August 14, 2019, 8:29pm UTC](https://forum.inductiveautomation.com/t/no-tag-historian-tables-created-in-database/19781/21 "2019-08-14T20:29:08Z")
Was having the similar issues as of Ignition version 8.0.3 using MySQL version 5.7-- tables weren’t being created even though the connection was valid and rooted. I could create tables using the DB query browser. Restarting gateway didn’t help. I was able to resolve the issue by manually adding the Connector/J (I used version 8.0.17) as a custom driver using all the regular options you’d use in the default-provided MySQL Connector/J driver. New connections using this custom driver worked. I’m not sure if I caused this somehow or if the issue is back as of Ignition 8, but either way, hope this helps someone. ---
**Author:** ![a.beltran](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/a.beltran/32/18481_2.png) [@a.beltran](https://forum.inductiveautomation.com/u/a.beltran)\ **Post date:** [April 16, 2020, 10:50pm UTC](https://forum.inductiveautomation.com/t/no-tag-historian-tables-created-in-database/19781/22 "2020-04-16T22:50:38Z")
Does anyone found out this issue. (java.sql.SQLSyntaxErrorException: Table ‘test.sqlth\_drv’ doesn’t exist) ---
**Author:** ![mike97112011](https://avatars.discourse-cdn.com/v4/letter/m/c57346/32.png) [@mike97112011](https://forum.inductiveautomation.com/u/mike97112011)\ **Post date:** [June 7, 2020, 1:23am UTC](https://forum.inductiveautomation.com/t/no-tag-historian-tables-created-in-database/19781/23 "2020-06-07T01:23:10Z")
I know this issue is a couple of years old however, I experienced this same problem. Particularly with Microsoft SQL Server. Each time I would use tag historian, each event was being passed to the Store and Forward Stores Quarantine with the error ‘sqlth\_drv’ is an invalid object. The problem ended up being that the user properties and permissions that ignition was using to connect to the database didn’t have the correct permissions and database references. Opening SQL Server Manager, Going to Object Explorer \> Security \> Logins \> Right Click the login account you’re connecting to through ignition and click “Properties”. On the General tab make sure that the “default database” points to the database you’re accessing through ignition. From there, make sure the user has database read/write and table creation permissions. That fixed it for me. ---
**Author:** ![ammar201031](https://avatars.discourse-cdn.com/v4/letter/a/7cd45c/32.png) [@ammar201031](https://forum.inductiveautomation.com/u/ammar201031)\ **Post date:** [January 21, 2022, 6:02pm UTC](https://forum.inductiveautomation.com/t/no-tag-historian-tables-created-in-database/19781/24 "2022-01-21T18:02:56Z")
Thank you man, That fixed for me too! ---
**Author:** ![Andrew\_Robinson](https://avatars.discourse-cdn.com/v4/letter/a/f05b48/32.png) [@Andrew\_Robinson](https://forum.inductiveautomation.com/u/Andrew_Robinson)\ **Post date:** [October 27, 2022, 2:23am UTC](https://forum.inductiveautomation.com/t/no-tag-historian-tables-created-in-database/19781/25 "2022-10-27T02:23:40Z")
Thanks mike, This just helped me get it working. ---
**Author:** ![jacque\_trahan](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jacque_trahan/32/58886_2.png) [@jacque\_trahan](https://forum.inductiveautomation.com/u/jacque_trahan)\ **Post date:** [December 10, 2025, 1:45pm UTC](https://forum.inductiveautomation.com/t/no-tag-historian-tables-created-in-database/19781/26 "2025-12-10T13:45:14Z")
> [@mike97112011](#): > > I know this issue is a couple of years old however, I experienced this same problem. Particularly with Microsoft SQL Server. Each time I would use tag historian, each event was being passed to the Store and Forward Stores Quarantine with the error ‘sqlth\_drv’ is an invalid object. The problem ended up being that the user properties and permissions that ignition was using to connect to the database didn’t have the correct permissions and database references. Opening SQL Server Manager, Going to Object Explorer \> Security \> Logins \> Right Click the login account you’re connecting to through ignition and click “Properties”. On the General tab make sure that the “default database” points to the database you’re accessing through ignition. From there, make sure the user has database read/write and table creation permissions. That fixed it for me. This was my issues as well. Thank you! [Previous page](https://forum.inductiveautomation.com/t/no-tag-historian-tables-created-in-database/19781.md?page=1)