# How to connect Ignition Gateway to Microsoft SQL Server 2014 with JDBC driver **URL:** \ **Category:** Ignition\ **Created:** [February 9, 2026, 12:10pm UTC](https://forum.inductiveautomation.com/t/how-to-connect-ignition-gateway-to-microsoft-sql-server-2014-with-jdbc-driver/113848 "2026-02-09T12:10:35Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![javier.allueva1](https://avatars.discourse-cdn.com/v4/letter/j/3bc359/32.png) [@javier.allueva1](https://forum.inductiveautomation.com/u/javier.allueva1)\ **Post date:** [February 9, 2026, 12:10pm UTC](https://forum.inductiveautomation.com/t/how-to-connect-ignition-gateway-to-microsoft-sql-server-2014-with-jdbc-driver/113848/1 "2026-02-09T12:10:35Z")
Good Morning, I have a gateway version 8.3 and I would like to connect to a Microsoft SQL 2014 server running in a different server, I can ping the other server and I can setup the OBDC Data sources/System DSN and test successfully the connection but when I add the database connection inside the Ignition gateway configuration the JDBC driver seems to be working only for new versions of Microsoft SQL server, is there a driver that I could download for older versions of Microsoft SQL Server? ---
**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Post date:** [February 9, 2026, 1:15pm UTC](https://forum.inductiveautomation.com/t/how-to-connect-ignition-gateway-to-microsoft-sql-server-2014-with-jdbc-driver/113848/2 "2026-02-09T13:15:34Z")
v12.6 was the latest for 2014 support. > **[Java and JDBC specification support - Support matrix - JDBC Driver for SQL...](https://learn.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?view=sql-server-ver17#java-and-jdbc-specification-support)** > > Download JDBC driver | This page contains the support matrix and support life-cycle policy for the Microsoft JDBC Driver for SQL Server. ---
**Author:** ![javier.allueva1](https://avatars.discourse-cdn.com/v4/letter/j/3bc359/32.png) [@javier.allueva1](https://forum.inductiveautomation.com/u/javier.allueva1)\ **Post date:** [February 9, 2026, 1:27pm UTC](https://forum.inductiveautomation.com/t/how-to-connect-ignition-gateway-to-microsoft-sql-server-2014-with-jdbc-driver/113848/3 "2026-02-09T13:27:00Z")
Thank you Jordan, I have downloaded this version and I have created a new JDBC driver on the Gateway, I pointed to the \*jar file on the extracted folder. It didn’t give me any errros when adding the driver but when I created a new database connection I got the following error: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/5/e51e02b6ad73bc765417899820121b07a6a63597.png) ---
**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:** [February 9, 2026, 1:28pm UTC](https://forum.inductiveautomation.com/t/how-to-connect-ignition-gateway-to-microsoft-sql-server-2014-with-jdbc-driver/113848/4 "2026-02-09T13:28:58Z")
See [Error connection SQL Server database after upgrade Ignition - #2 by Kevin.Herron](https://forum.inductiveautomation.com/t/error-connection-sql-server-database-after-upgrade-ignition/53281/2) or similar posts. It might also be worth trying to add `encrypt=false;` to the connection parameters before any of the more difficult suggestions. ---
**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:** [February 9, 2026, 2:40pm UTC](https://forum.inductiveautomation.com/t/how-to-connect-ignition-gateway-to-microsoft-sql-server-2014-with-jdbc-driver/113848/5 "2026-02-09T14:40:39Z")
I don't know if it's quite relevant to your situation, but some of what I learned on this thread may be of interest. > [@SQL Express 2005 database connection ideas?](https://forum.inductiveautomation.com/t/sql-express-2005-database-connection-ideas/78728): > > I have two machines running SQL Express 2005 behind their FactoryTalk View Studio HMIs. The machines are software validated (medical device manufacturing environment) so I really don't want to mess with the configuration. When the machines arrived about 15 years ago I got the vendor to create piped connections with read-only access to the database and was able to create some very useful PHP web pages on one of our servers to create web reports on producion, recipes, machine settings, etc. I'd l… ---
**Author:** ![javier.allueva1](https://avatars.discourse-cdn.com/v4/letter/j/3bc359/32.png) [@javier.allueva1](https://forum.inductiveautomation.com/u/javier.allueva1)\ **Post date:** [February 9, 2026, 3:11pm UTC](https://forum.inductiveautomation.com/t/how-to-connect-ignition-gateway-to-microsoft-sql-server-2014-with-jdbc-driver/113848/6 "2026-02-09T15:11:45Z")
Thank you Kevin and the rest for jumping on this, after upgrading the SQL Server 14 to the right version to suppport TSL , the connection worked fine, thank you so much