# SQL Server - Telling Ignition to use a different schema besides \[dbo\] for Historical Data?

**URL:** <https://forum.inductiveautomation.com/t/sql-server-telling-ignition-to-use-a-different-schema-besides-dbo-for-historical-data/59436>\
**Category:** Ignition\
**Created:** [May 10, 2022, 9:42pm UTC](https://forum.inductiveautomation.com/t/sql-server-telling-ignition-to-use-a-different-schema-besides-dbo-for-historical-data/59436 "2022-05-10T21:42:57Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![tmahaf](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tmahaf/32/23492_2.png) [@tmahaf](https://forum.inductiveautomation.com/u/tmahaf)\
**Post date:** [May 10, 2022, 9:42pm UTC](https://forum.inductiveautomation.com/t/sql-server-telling-ignition-to-use-a-different-schema-besides-dbo-for-historical-data/59436/1 "2022-05-10T21:42:57Z")

</div>

I am not seeing any option to tell Ignition to use anything besdies the default schema for the database its connected to. Is there any way to point it to use any other schema besides dbo?

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [May 10, 2022, 9:56pm UTC](https://forum.inductiveautomation.com/t/sql-server-telling-ignition-to-use-a-different-schema-besides-dbo-for-historical-data/59436/2 "2022-05-10T21:56:49Z")

</div>

No. You could just make an additional DB connection in Ignition (to the same actual database server) with the different schema specified.

---

<div class="post-metadata">

**Author:** ![tmahaf](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tmahaf/32/23492_2.png) [@tmahaf](https://forum.inductiveautomation.com/u/tmahaf)\
**Post date:** [May 10, 2022, 9:58pm UTC](https://forum.inductiveautomation.com/t/sql-server-telling-ignition-to-use-a-different-schema-besides-dbo-for-historical-data/59436/3 "2022-05-10T21:58:53Z")

</div>

Where do you set the schema?

Under extra connection props, I only find an option for database name:

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

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [May 10, 2022, 9:59pm UTC](https://forum.inductiveautomation.com/t/sql-server-telling-ignition-to-use-a-different-schema-besides-dbo-for-historical-data/59436/4 "2022-05-10T21:59:51Z")

</div>

MSSQL calls what every other DB calls “schemas”, “databases”, from what I understand.

---

<div class="post-metadata">

**Author:** ![tmahaf](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tmahaf/32/23492_2.png) [@tmahaf](https://forum.inductiveautomation.com/u/tmahaf)\
**Post date:** [May 10, 2022, 10:01pm UTC](https://forum.inductiveautomation.com/t/sql-server-telling-ignition-to-use-a-different-schema-besides-dbo-for-historical-data/59436/5 "2022-05-10T22:01:37Z")

</div>

Are you sure? That is the name of our database, not schema

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

---

<div class="post-metadata">

**Author:** ![kcollins](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kcollins/32/19646_2.png) [@kcollins](https://forum.inductiveautomation.com/u/kcollins)\
**Post date:** [May 10, 2022, 10:22pm UTC](https://forum.inductiveautomation.com/t/sql-server-telling-ignition-to-use-a-different-schema-besides-dbo-for-historical-data/59436/6 "2022-05-10T22:22:58Z")

</div>

One thing that I’ll provide here is that Ignition will use whatever the _Default Schema_ is configured for the defined user. See the example below where I modified the `ignition` user I’m using to connect Ignition to my MSSQL DB to use a schema `foo` (instead of the default `dbo`):

 ![Screenshot 2022-05-10 171930](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/4/14c5b6966b69fcefbee7166759cdd62e2808a4ae.png)

I’m not sure offhand of what might be able to be done to specify a schema for MSSQL over the JDBC connection properties… I figured I’d mention the above though if that might be a good solution for you…

EDIT: it appears that this might actually be the way to go; doesn’t seem like you can specify the schema via the JDBC connection properties.

---

<div class="post-metadata">

**Author:** ![thecesrom.git](https://avatars.discourse-cdn.com/v4/letter/t/dfb087/32.png) [@thecesrom.git](https://forum.inductiveautomation.com/u/thecesrom.git)\
**Post date:** [May 11, 2022, 2:09am UTC](https://forum.inductiveautomation.com/t/sql-server-telling-ignition-to-use-a-different-schema-besides-dbo-for-historical-data/59436/7 "2022-05-11T02:09:55Z")

</div>

This is exactly what I’ve been doing; creating an `ignition` login that owns and defaults to the `ignition` schema. As well as being part of the `dbo` group so it’s able to create tables unrestricted.