From time to time we get a customer reporting an error like this:
The key to this error is the text “Faled to load the sqljdbc_auth.dll”
This file is required by the Microsoft SQL Server JDBC driver, in order to handle integrated authentication.
The file must be placed in the Java bin folder. Upgrades to Java can change the location of the Java in folder, by changing the version number higher up the path. This means that the file can no longer be found.
Here are some instructions to resolve this error if it occurs on your server.
Download the SQL Server JDBC driver from https://www.microsoft.com/en-au/download/details.aspx?id=11774. Make sure you get the 64-bit version.
Install the driver to any location. It doesn’t matter where, it basically just unzips a file structure and you’ll only be taking one file from its directory.
Go to the folder to which you installed the driver, and find the following path:
Copy the file sqljdbc_auth.dll from this location
Find the location of your Java Runtime Environment using the WHERE command:
It should be something like this:
Copy the sqljdbc_auth.dll into the java folder. Given the result I’ve just shown, on my machine I would copy it to:
Now, when you restart the Ajilius application, integrated authentication should work on your machine.