SQL Server & Trusted Connection

I was experiencing an error saying the file “sqljdbc_auth” file was not found. I first tried to download the sqljdbc_10.2 from microsoft but it did not contain a file exactly named “sqljdbc_auth.dll.” It was called “mssql-jdbc_auth-10.2.0.x64.dll.” Wasn’t sure if I could just move the file without renaming it to “sqljdbc_auth” or not.

We are setting up a separate server for testing and our existing production server was already working. I wasn’t sure exactly where the sqljdbc_auth.dll needed to be added so I compared the files between the two servers located in the ignition directory “Program Files\ Inductive Automation\ Ignition\lib.” I saw that the test server was missing the “sqljdbc_auth.dll” file so I copied and pasted it into the test server. I restarted the server and I didn’t see the error after that.

I never tried using the file “mssql-jdbc_auth-10.2.0.x64.dll” from Microsoft but i’m guessing i could have renamed it and placed it in the “lib” directory to fix the issue.