# Azure SQL Database Ignition Compatibility

**URL:** <https://forum.inductiveautomation.com/t/azure-sql-database-ignition-compatibility/58133>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [April 6, 2022, 11:06pm UTC](https://forum.inductiveautomation.com/t/azure-sql-database-ignition-compatibility/58133 "2022-04-06T23:06:24Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![knicholas](https://avatars.discourse-cdn.com/v4/letter/k/71e660/32.png) [@knicholas](https://forum.inductiveautomation.com/u/knicholas)\
**Post date:** [April 6, 2022, 11:06pm UTC](https://forum.inductiveautomation.com/t/azure-sql-database-ignition-compatibility/58133/1 "2022-04-06T23:06:24Z")

</div>

Has anyone used or connected their Ignition Project with Azure SQL Database?

I cannot find any information on the compatibility with Azure SQL Database with Ignition 8.1. I wanted to use Azure SQL Database instead of just a VM with MSSQL.

If so, are you happy with the result? What is the server spec and how many tags does your project use?

---

<div class="post-metadata">

**Author:** ![josborn](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@josborn](https://forum.inductiveautomation.com/u/josborn)\
**Post date:** [April 6, 2022, 11:34pm UTC](https://forum.inductiveautomation.com/t/azure-sql-database-ignition-compatibility/58133/2 "2022-04-06T23:34:02Z")

</div>

I have not, but if you search for topics, it looks like it's been done.

> [@Ignition connection to Azure SQL Database](https://forum.inductiveautomation.com/t/ignition-connection-to-azure-sql-database/16063):
>
> Hi, I’m having trouble connecting to an Azure SQL database from a separate Igniton server. This is how I set it up: Microsoft SQLServer JDBC Driver Connect URL: jdbc:sqlserver://SQL server [name.database.windows.net](http://name.database.windows.net) Username: SQL user name databaseName=Existing database in SQL server What should I use as the instanceName? Do I also need to allow port 1433 or 1434 as a firewall outbound rule on the Ignition server? I can connect to the database via SQL management studio on the Ignition ser…

---

<div class="post-metadata">

**Author:** ![knicholas](https://avatars.discourse-cdn.com/v4/letter/k/71e660/32.png) [@knicholas](https://forum.inductiveautomation.com/u/knicholas)\
**Post date:** [April 14, 2022, 2:52pm UTC](https://forum.inductiveautomation.com/t/azure-sql-database-ignition-compatibility/58133/3 "2022-04-14T14:52:29Z")

</div>

@josborn, I have successfully connected it to the Azure SQL database.

The steps are pretty easy. You just have to use the JDBC connector from the Azure SQL database and its address. Almost the same steps as using MSSQL/Express.

---

<div class="post-metadata">

**Author:** ![ryanjmclaughlin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryanjmclaughlin/32/4318_2.png) [@ryanjmclaughlin](https://forum.inductiveautomation.com/u/ryanjmclaughlin)\
**Post date:** [April 14, 2022, 4:37pm UTC](https://forum.inductiveautomation.com/t/azure-sql-database-ignition-compatibility/58133/4 "2022-04-14T16:37:34Z")

</div>

Just moved a bunch of our old MSSQL DBs to Azure SQL. Ignition was easy, just change the connection string. I would make sure to update your JDBC driver to the latest. I used the DTU based tiers, its very easy to monitor performance and bump up or down accordingly.