# Issue regarding SQL Connectivity with Ignition

**URL:** <https://forum.inductiveautomation.com/t/issue-regarding-sql-connectivity-with-ignition/59383>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [May 10, 2022, 3:36am UTC](https://forum.inductiveautomation.com/t/issue-regarding-sql-connectivity-with-ignition/59383 "2022-05-10T03:36:00Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kartik\_I](https://avatars.discourse-cdn.com/v4/letter/k/8c91f0/32.png) [@Kartik\_I](https://forum.inductiveautomation.com/u/Kartik_I)\
**Post date:** [May 10, 2022, 3:36am UTC](https://forum.inductiveautomation.com/t/issue-regarding-sql-connectivity-with-ignition/59383/1 "2022-05-10T03:36:00Z")

</div>

Hello,

` I am facing SQL connectivity with Ignition 8.1. I am having 2 gateways the SQL connection for one gateway is working fine but its not working with another backup so any guess why it is acting like this.`

![Error Database](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/8/d8541c45ab2a85d5193b607f9e778e1cfca4fb86.png)

Thanks,  
Kartik

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [May 10, 2022, 5:47am UTC](https://forum.inductiveautomation.com/t/issue-regarding-sql-connectivity-with-ignition/59383/2 "2022-05-10T05:47:02Z")

</div>

You’ve managed to post your question paragraph as code. Can you remove the leading spaces from the paragraph and the text will wrap properly?

I think you’ll need to supply more details before anyone could help.

---

<div class="post-metadata">

**Author:** ![Kartik\_I](https://avatars.discourse-cdn.com/v4/letter/k/8c91f0/32.png) [@Kartik\_I](https://forum.inductiveautomation.com/u/Kartik_I)\
**Post date:** [May 10, 2022, 2:14pm UTC](https://forum.inductiveautomation.com/t/issue-regarding-sql-connectivity-with-ignition/59383/3 "2022-05-10T14:14:21Z")

</div>

thanks @Transistor

---

<div class="post-metadata">

**Author:** ![Matthew.gaitan](https://avatars.discourse-cdn.com/v4/letter/m/59ef9b/32.png) [@Matthew.gaitan](https://forum.inductiveautomation.com/u/Matthew.gaitan)\
**Post date:** [May 10, 2022, 2:16pm UTC](https://forum.inductiveautomation.com/t/issue-regarding-sql-connectivity-with-ignition/59383/4 "2022-05-10T14:16:39Z")

</div>

Please see this article on getting this working again:

> **[TLS v1.0 and v1.1 Microsoft SQL Server Database connection issue](https://support.inductiveautomation.com/hc/en-us/articles/4417310204813-TLS-v1-0-and-v1-1-Microsoft-SQL-Server-Database-connection-issue)**
>
> Summary
> A recent update to Java 8 (8u291), which also applies to Java 11.0.11 and above, has disabled TLS 1.0 and 1.1. This has resulted in cases of Ignition's connection to Microsoft SQL Server (M...

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [May 10, 2022, 2:19pm UTC](https://forum.inductiveautomation.com/t/issue-regarding-sql-connectivity-with-ignition/59383/5 "2022-05-10T14:19:51Z")

</div>

You haven’t mastered it yet. It’s still formatted as code (`recognisable by the fixed space font and shaded background like this`) although you have inserted some line breaks.

Regarding the question, SQL Server requires set up for remote access. Articles such as [this one](https://knowledgebase.apexsql.com/configure-remote-access-connect-remote-sql-server-instance-apexsql-tools/) explain how.

---

<div class="post-metadata">

**Author:** ![Kartik\_I](https://avatars.discourse-cdn.com/v4/letter/k/8c91f0/32.png) [@Kartik\_I](https://forum.inductiveautomation.com/u/Kartik_I)\
**Post date:** [May 10, 2022, 3:22pm UTC](https://forum.inductiveautomation.com/t/issue-regarding-sql-connectivity-with-ignition/59383/6 "2022-05-10T15:22:03Z")

</div>

Thanks @Matthew.gaitan It solved my problem.
