I also reviewed Travis’ training video on database connections and tried to do everything required there. I still can’t get it to work.
I’ve successfully configured a connection on the same box using SQL Server security.
My error message is:
[quote] org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication.)
com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication.
I’m trying to configure it on a VM running Windows Server 2008R2, SQL Server 2008/10 and MS JDBC V3.0 driver.
Did you try taking a look at Connecting to MS SQL Server? Connecting to SQLServer is sometimes a pain, but it always works after downloading the right sqljdbc_auth.dll file and turning on the browser, TCP/IP, etc. The error Cannot create PoolableConnectionFactory doesn’t really tell us much about why it can’t connect, but I would double check which sqljdbc_auth.dll file you loaded and make sure you restarted the SQLServer service after changing it’s settings.
Had issue. But fixed it.
If I followed default instructions I had an error 1(fig 1 File Missing). I have some hard time to figure out what i can do… After i had an idea just not to rename file as they telling in the instruction → Had another issue (fig 2 File missing). Then i just keep 2 files (1 renamed and 1 not) at the folder and all works fine → looks stooping because it’s the same files, but working - so will use until they fix issue.
I was having trouble connecting with Windows Authentication as well. I found that I was getting a similar error from the Gateway Status page...
Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication.
I noticed further down in the stack trace however, that the driver version Ignition was looking for did not match the latest version I downloaded (per the User Manual Guide: Connecting to Microsoft SQL Server, Scenario 2: Connect By Using Instance Name and Windows Authentication)
java.lang.UnsatisfiedLinkError: no mssql-jdbc_auth-9.4.0.x64 in java.library.path: [lib, lib\core\gateway]
I sought out, and downloaded the mssql-jdbc_auth-X.X.X.x64.dll file that matched the mssql-jdbc-9.4.0.jre11.jar file located in C:\Program Files\Inductive Automation\Ignition\user-lib\jdbc, which was 9.4.0 in my case. I put that file in the location described by the connection guide and my connection worked.
TL;DR, The connection guide should be updated to specify that the DLL file you want should match the mssql-jdbc JAR file in your user-lib/jdbc directory, instead of just "...it's recommended you use the most recent driver available for your system".
Specs: Ignition 8.1.21, Running on Windows Server 2019.
Thanks for updating that quickly. I just saw the note this morning that thought I may have missed it all along! I think this will be very helpful for folks.
Perhaps a reference to where people can find that jdbc driver would be helpful too. In my case it was found in user-lib within the install directory. I didn't see anything that looked like a version number on the config page of the gateway but perhaps there's an easier way to identify the version.
That's a good point! Looking in the install directory is the best way to see it. I know we have a note in this KBA that mentions the location but it's geared towards a different issue. I'll see if our docs team can get a note added about the location in the install directory on that user manual page as well.