# Connection to microsoft SQL dB

**URL:** <https://forum.inductiveautomation.com/t/connection-to-microsoft-sql-db/95096>\
**Category:** Ignition\
**Created:** [August 23, 2024, 5:39pm UTC](https://forum.inductiveautomation.com/t/connection-to-microsoft-sql-db/95096 "2024-08-23T17:39:31Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nathaniel\_Webb](https://avatars.discourse-cdn.com/v4/letter/n/e8c25b/32.png) [@Nathaniel\_Webb](https://forum.inductiveautomation.com/u/Nathaniel_Webb)\
**Post date:** [August 23, 2024, 5:39pm UTC](https://forum.inductiveautomation.com/t/connection-to-microsoft-sql-db/95096/1 "2024-08-23T17:39:31Z")

</div>

Hello,  
I have been working some time on creating a transaction group that sends to a Microsoft SQL database. I have done it successfully with a mySQL database, but I cannot seem to establish a valid connection with microsft SQl.  
here are my details:

port is 1433 which is default  
The data name is RTOdata, so would this be the instance name or the extra connection property.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/5/5534b5a963fcec9111db1e416da9c1d77e3b9763.png)

---

<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:** [August 23, 2024, 5:46pm UTC](https://forum.inductiveautomation.com/t/connection-to-microsoft-sql-db/95096/2 "2024-08-23T17:46:58Z")

</div>

Have you tried putting `RTOData` after the `\` in your URL like it suggests?

What's the error you're getting?

---

<div class="post-metadata">

**Author:** ![Benjamin\_Furlani](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/benjamin_furlani/32/66084_2.png) [@Benjamin\_Furlani](https://forum.inductiveautomation.com/u/Benjamin_Furlani)\
**Post date:** [August 24, 2024, 12:55am UTC](https://forum.inductiveautomation.com/t/connection-to-microsoft-sql-db/95096/3 "2024-08-24T00:55:51Z")

</div>

> [@Nathaniel\_Webb](#):
>
> The data name is RTOdata

Do you mean database name?

If it is a SQLExpress Server it will require you to have SQLExpress as the instance name. You would connect to this the same way you would connect to it through SSMS in terms of the path. Most standard SQL Server Installations come as MSSQLSERVER as the instance name (you can check the instance name based on the name of the service that is running typically)

---

<div class="post-metadata">

**Author:** ![diamond](https://avatars.discourse-cdn.com/v4/letter/d/e79b87/32.png) [@diamond](https://forum.inductiveautomation.com/u/diamond)\
**Post date:** [August 24, 2024, 11:36am UTC](https://forum.inductiveautomation.com/t/connection-to-microsoft-sql-db/95096/4 "2024-08-24T11:36:10Z")

</div>

I solved a similar problem just by defining the port in the connection URL, even if using the default.

---

<div class="post-metadata">

**Author:** ![michael.flagler](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/michael.flagler/32/26272_2.png) [@michael.flagler](https://forum.inductiveautomation.com/u/michael.flagler)\
**Post date:** [August 26, 2024, 5:32am UTC](https://forum.inductiveautomation.com/t/connection-to-microsoft-sql-db/95096/5 "2024-08-26T05:32:12Z")

</div>

With SQL Express you'll also have to enable TCP connections. Search the forums and watch the Inductive University video on how to set up MS SQL. Do be aware of the limitions of the express version as it has a limited database size.