How to connect Ignition Gateway to Microsoft SQL Server 2014 with JDBC driver

Ignition
1

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?

2

v12.6 was the latest for 2014 support.

3

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
image330×177 4.78 KB

4

See Error connection SQL Server database after upgrade Ignition - #2 by Kevin.Herron or similar posts.

It might also be worth trying to add encrypt=false; to the connection parameters before any of the more difficult suggestions.

5

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.

6

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