# SQL Server on same VM as Gateway?

**URL:** <https://forum.inductiveautomation.com/t/sql-server-on-same-vm-as-gateway/23490>\
**Category:** Ignition\
**Created:** [March 20, 2019, 6:28pm UTC](https://forum.inductiveautomation.com/t/sql-server-on-same-vm-as-gateway/23490 "2019-03-20T18:28:24Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![brandon.hughes](https://avatars.discourse-cdn.com/v4/letter/b/3e96dc/32.png) [@brandon.hughes](https://forum.inductiveautomation.com/u/brandon.hughes)\
**Post date:** [March 20, 2019, 6:28pm UTC](https://forum.inductiveautomation.com/t/sql-server-on-same-vm-as-gateway/23490/1 "2019-03-20T18:28:24Z")

</div>

Hi,

My company has recently purchased Ignition, and we are in the process of setting up the gateway on a VM. The question I have is, would it be practical to set up our SQL server on the same VM as our gateway?

Thanks in advance

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [March 20, 2019, 6:29pm UTC](https://forum.inductiveautomation.com/t/sql-server-on-same-vm-as-gateway/23490/2 "2019-03-20T18:29:24Z")

</div>

It’s probably okay initially, but you may eventually need to move it to its own server if performance becomes an issue.

---

<div class="post-metadata">

**Author:** ![brandon.hughes](https://avatars.discourse-cdn.com/v4/letter/b/3e96dc/32.png) [@brandon.hughes](https://forum.inductiveautomation.com/u/brandon.hughes)\
**Post date:** [March 20, 2019, 6:31pm UTC](https://forum.inductiveautomation.com/t/sql-server-on-same-vm-as-gateway/23490/3 "2019-03-20T18:31:03Z")

</div>

Thanks for the prompt response. Also, is there a preferred SQL server version that works best with Ignition 8.0? We are planning on using MSSQL Server 2017.

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [March 20, 2019, 6:32pm UTC](https://forum.inductiveautomation.com/t/sql-server-on-same-vm-as-gateway/23490/4 "2019-03-20T18:32:30Z")

</div>

That falls within the [support matrix](https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?view=sql-server-2017) so it should be fine.