# How to reset Gateway looking for History tables?

**URL:** <https://forum.inductiveautomation.com/t/how-to-reset-gateway-looking-for-history-tables/92926>\
**Category:** Ignition\
**Created:** [July 8, 2024, 10:25pm UTC](https://forum.inductiveautomation.com/t/how-to-reset-gateway-looking-for-history-tables/92926 "2024-07-08T22:25:41Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mdemaris](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mdemaris/32/54639_2.png) [@mdemaris](https://forum.inductiveautomation.com/u/mdemaris)\
**Post date:** [July 8, 2024, 10:25pm UTC](https://forum.inductiveautomation.com/t/how-to-reset-gateway-looking-for-history-tables/92926/1 "2024-07-08T22:25:41Z")

</div>

Server: MSSQL  
Logins: dual - one for users, one for tag history

I am trying to get Tag History working and got it but the default schema was `dbo`. Well, I want it to use another schema.  
So, I posted some questions here:

> [@SQL database structure recommendations](https://forum.inductiveautomation.com/t/sql-database-structure-recommendations/33234/8):
>
> And this is where I have a question or two: I am attempting to use tag history with MSSQL, but I am not sure how. I get errors stating that the table (sqlth\_drv) cannot be created. In this particular development environment, I have a user (Ignition) that is also used for the Perspective to access the DB. Can I, or should I, use this same user? Can I change the schema the tag historian will write to, instead of dbo? Are there any specific permissions required for the user, in the Securables …

After creating the second login/user for the DB, set the default schema to `test`, and set it as the owner and member of `db_ddladmin` as well. That didn't seem to work. Ignition kept looking for the `dbo` schema even though it was not accessible to that particular login.

So, I deleted the history tables, and tried again. And Ignition is still looking for those tables (`Invalid object name 'sqlt_data_1_2024_07'`) and that schema. How do I reset the project or Gateway and allow it to use the other user with `test` schema? I do not see anything in the Gateway Config that allows for something like that.

Thanks

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [July 9, 2024, 12:31am UTC](https://forum.inductiveautomation.com/t/how-to-reset-gateway-looking-for-history-tables/92926/2 "2024-07-09T00:31:02Z")

</div>

It would be an extra connection property specific to the JDBC driver you are using. Since it is MS SQL, some one else will have to chime in. Or perhaps you can figure it out from Microsoft's documentation.