# MSSQL Connection Fault

**URL:** <https://forum.inductiveautomation.com/t/mssql-connection-fault/73454>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [May 9, 2023, 7:26am UTC](https://forum.inductiveautomation.com/t/mssql-connection-fault/73454 "2023-05-09T07:26:04Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![p.srikanth0707](https://avatars.discourse-cdn.com/v4/letter/p/e47774/32.png) [@p.srikanth0707](https://forum.inductiveautomation.com/u/p.srikanth0707)\
**Post date:** [May 9, 2023, 7:26am UTC](https://forum.inductiveautomation.com/t/mssql-connection-fault/73454/1 "2023-05-09T07:26:05Z")

</div>

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/5/65add5d7d130b778f91329103e921f8d9dee2f6a.png)  
Hello Folks,

I am trying to connect with MSSQL 2022 and Ignition V8.1.22, There are some relevant posts, but I could not figure out what needs to be done exactly.

Regards,  
SPI

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [May 9, 2023, 12:21pm UTC](https://forum.inductiveautomation.com/t/mssql-connection-fault/73454/2 "2023-05-09T12:21:36Z")

</div>

Some topics for you:

[https://forum.inductiveautomation.com/search?q=SQL%20Server%20javax.net.ssl.SSLHandshakeException](https://forum.inductiveautomation.com/search?q=SQL%20Server%20javax.net.ssl.SSLHandshakeException)

---

<div class="post-metadata">

**Author:** ![p.srikanth0707](https://avatars.discourse-cdn.com/v4/letter/p/e47774/32.png) [@p.srikanth0707](https://forum.inductiveautomation.com/u/p.srikanth0707)\
**Post date:** [May 11, 2023, 4:52am UTC](https://forum.inductiveautomation.com/t/mssql-connection-fault/73454/3 "2023-05-11T04:52:44Z")

</div>

Thank you @pturmel

Finally, my connection is made with the database.

with the following steps:

1. Updated the JDBC drivers JAR file with interactions from [IA](https://docs.inductiveautomation.com/display/DOC81/JDBC+Drivers+and+Translators) and DLL file

> C:\Program Files\Inductive Automation\Ignition\lib (Copied .dll file in this path/mssql-jdbc\_auth-12.2.0.x64.dll)

> C:\Program Files\Inductive Automation\Ignition\lib\core\gateway

1. Added security logins in SSMS -- [NT AUTHORITY\NETWORK SERVICE](https://serverfault.com/questions/469944/how-to-add-network-service-to-users-permission-group)

2. Enabled [TLS 1.4](https://learn.microsoft.com/en-us/dotnet/framework/network-programming/tls) as my version is V4.0.30319

3. Extra connection properties in the ignition gateway - databaseName=Test;Integrated Security=true;encrypt=false;

"That's all I remember - it was fixed, and its status is now valid after I spent the whole day working on it."

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