# JDBC sqljdbc4.jar version? **URL:** \ **Category:** Ignition\ **Tags:** ignition81\ **Created:** [January 18, 2022, 9:00pm UTC](https://forum.inductiveautomation.com/t/jdbc-sqljdbc4-jar-version/55141 "2022-01-18T21:00:20Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Jordan\_Larson](https://avatars.discourse-cdn.com/v4/letter/j/c5a1d2/32.png) [@Jordan\_Larson](https://forum.inductiveautomation.com/u/Jordan_Larson)\ **Post date:** [January 18, 2022, 9:00pm UTC](https://forum.inductiveautomation.com/t/jdbc-sqljdbc4-jar-version/55141/1 "2022-01-18T21:00:20Z")
Greetings! I’m trying to track down the version of the JDBC version for MSSQL that is packaged with Ignition 8.1.13. I know the connector is not touched during upgrades and this is a fresh installation. Checking Google and the forums didn’t turn up much other than checking the manifest but that didn’t unfortunately turn up much. ```auto # unzip -p sqljdbc4.jar META-INF/MANIFEST.MF | grep version Name: com/microsoft/sqlserver/jdbc/JDBCType$UpdaterConversion.class Name: com/microsoft/sqlserver/jdbc/JDBCType$SetterConversion.class Name: com/microsoft/sqlserver/jdbc/SSType$GetterConversion.class ``` I’m trying to figure out which connection properties are supported and that depends on the version. I would venture to guess it’s pretty new but just trying to confirm. Why I’m asking this is I’m trying to configure a DB connection from a Linux host running RHEL 8.5/Ignition 8.1.13 to a Domain joined MSSQL box running Windows without much success. The trace just indicates a failed username/password but I suspect it’s probably because the Linux host isn’t joined on the domain and there might be an “extra connection string” I need to play with so I can authenticate to the MSSQL using AD credentials instead of Local SQL Auth. Local SQL auth works without any issues I checked this page for any information: [https://docs.inductiveautomation.com/display/DOC81/JDBC+Drivers+and+Translators](https://docs.inductiveautomation.com/display/DOC81/JDBC+Drivers+and+Translators) Here is the list of connection properties I was browsing: > **[Setting the connection properties - JDBC Driver for SQL Server](https://docs.microsoft.com/en-us/sql/connect/jdbc/setting-the-connection-properties?view=sql-server-ver15)** > > The connection string properties for the Microsoft JDBC Driver for SQL Server can be specified in various ways. If anyone has any pointers - that would be fantastic. Thanks! ~Jordan ---
**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:** [January 18, 2022, 9:16pm UTC](https://forum.inductiveautomation.com/t/jdbc-sqljdbc4-jar-version/55141/2 "2022-01-18T21:16:27Z")
For a fresh install I think it’s version 7.2.1. Take a look at the JAR file for the driver in the `$IGNITION/user-lib/jdbc` folder. ---
**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:** [January 18, 2022, 9:19pm UTC](https://forum.inductiveautomation.com/t/jdbc-sqljdbc4-jar-version/55141/3 "2022-01-18T21:19:56Z")
> [@Jordan\_Larson](#): > > `# unzip -p sqljdbc4.jar META-INF/MANIFEST.MF | grep version` Ah, if you really have a `sqljdbc4.jar` version there's no embedded version info but it's safe to say it's ancient and you should probably upgrade unless you have connections to old versions of SQL Server you need to maintain. ---
**Author:** ![Jordan\_Larson](https://avatars.discourse-cdn.com/v4/letter/j/c5a1d2/32.png) [@Jordan\_Larson](https://forum.inductiveautomation.com/u/Jordan_Larson)\ **Post date:** [January 18, 2022, 9:36pm UTC](https://forum.inductiveautomation.com/t/jdbc-sqljdbc4-jar-version/55141/4 "2022-01-18T21:36:12Z")
Hey Kevin - thanks for the response! This is just a default installation for 8.1.13. Sounds like the included JAR is pretty old? Not what I would have expected! We do have some older MSSQL systems, but I have zero issues trying to get it an upgrade (in a lower environment of course). To get AD Auth setup for MSSQL, has it generally required a JDBC upgrade? Thanks! ~Jordan ---
**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:** [January 18, 2022, 9:46pm UTC](https://forum.inductiveautomation.com/t/jdbc-sqljdbc4-jar-version/55141/5 "2022-01-18T21:46:37Z")
> [@Jordan\_Larson](#): > > To get AD Auth setup for MSSQL, has it generally required a JDBC upgrade? No, not really. What version of the JDBC driver you need depends on the version of Java (11 for Ignition 8+) and the version of SQL Server you are connecting to. See the compatibility matrix from Microsoft here: [Support matrix - JDBC Driver for SQL Server | Microsoft Learn](https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?view=sql-server-ver15&viewFallbackFrom=sql-server-ver16) Also if by AD auth you're talking about integrated security or whatever I don't think that works at all on Linux. On Windows there are extra steps where you need to put a Microsoft-provided DLL into the right location. See [https://support.inductiveautomation.com/hc/en-us/articles/360047131512-Microsoft-SQL-Server-MSSQL-Connection-Guide-for-Ignition](https://support.inductiveautomation.com/hc/en-us/articles/360047131512-Microsoft-SQL-Server-MSSQL-Connection-Guide-for-Ignition) ---
**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:** [January 18, 2022, 9:56pm UTC](https://forum.inductiveautomation.com/t/jdbc-sqljdbc4-jar-version/55141/6 "2022-01-18T21:56:20Z")
Also I’m seeing version 9.4.0 in the 8.1.13 linux zip file: ![Screen Shot 2022-01-18 at 1.55.08 PM](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/b/cbd63f8ffd7fe480a617cb1c6bcaefe919cce12a.png) ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [January 18, 2022, 9:57pm UTC](https://forum.inductiveautomation.com/t/jdbc-sqljdbc4-jar-version/55141/7 "2022-01-18T21:57:42Z")
> [@Jordan\_Larson](#): > > Sounds like the included JAR is pretty old? Did you restore a .gwbk? For deliberate compatibility reasons, we put your JDBC drivers into the .gwbk and replace the ones on a gateway when you restore. ---
**Author:** ![Jordan\_Larson](https://avatars.discourse-cdn.com/v4/letter/j/c5a1d2/32.png) [@Jordan\_Larson](https://forum.inductiveautomation.com/u/Jordan_Larson)\ **Post date:** [January 18, 2022, 10:06pm UTC](https://forum.inductiveautomation.com/t/jdbc-sqljdbc4-jar-version/55141/8 "2022-01-18T22:06:34Z")
No restore - this is a fresh and empty installation I’m playing with using the .run installer. Looks like the zip lists the actual version, that was very helpful, thank you! Ignition user auth will be configured via LDAPS to AD. I’m just playing with DB connections at the moment. I was thinking I could connect in ignition to MSSQL using mydomain\mssqluser or [mssqluser@mydomain.com](mailto:mssqluser@mydomain.com). Configured plenty of Linux based apps with LDAPS to AD with zero issues. I’m also the furthest from being a MSSQL expert which in this case doesn’t help too much. Appreciate the discussion here! Thanks! ~Jordan ---
**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:** [January 19, 2022, 1:14am UTC](https://forum.inductiveautomation.com/t/jdbc-sqljdbc4-jar-version/55141/9 "2022-01-19T01:14:44Z")
I believe you would need to set up a Windows user in the db as well (can also be a group), if you haven’t already done so. It may also help to know what version of SQL Server you’re using. ---
**Author:** ![Jordan\_Larson](https://avatars.discourse-cdn.com/v4/letter/j/c5a1d2/32.png) [@Jordan\_Larson](https://forum.inductiveautomation.com/u/Jordan_Larson)\ **Post date:** [January 19, 2022, 3:16pm UTC](https://forum.inductiveautomation.com/t/jdbc-sqljdbc4-jar-version/55141/10 "2022-01-19T15:16:30Z")
Hey Jordan, The user is already present (hence my confusion on why it doesn’t work). Which at this point I’m pretty confident is a user error on my part. I suspect I need to add something else to “Extra Connection Properties” in Ignition perhaps. Version of the DB is MSSQL Server 2019 CU8 (15.0.4073.23).