Hello Austin,
unfortunately it is not possible to setup the native authentication via “Customization profiles” since it requires changes in the knime.ini file which is only loaded during startup.
What I would suggest is to setup one KNIME Analytics Platform/Executor to support native authentication which you can distribute by simply copy and paste the sqljdbc_auth.dll into the following folder:
<KNIME_INSTALLATION_FOLDER>plugins\org.knime.binary.jre.win32.x86_64_1.8.0.202-b08\jre\bin
The Microsoft SQL Connector node will then be able to load the dll-file automatically.
As an alternative you can also add the path to the dll-file in the knime.ini file of each installation by adding the following line to the end:
-Djava.library.path=<path to dll >
Bye
Tobias
1 Like