By default, the Flow server will connect to its configured database using a username and password as defined in database properties. Some sites may require that SQL Server use Windows Authentication mode exclusively. Here is how you can configure the Flow server to use integrated security to connect to such a database, using the Flow service user to authenticate rather than a defined username and password.
- Download the Microsoft JDBC driver.
- Find sqljdbc_auth.dll in the downloaded files, and place it in the <FlowInstallDir>\server\lib directory.
- In database configuration file <FlowDataDir>\conf\database.properties, add your custom JDBC URL that connects using ISS by setting COMMANDER_CUSTOM_DB_URL with integratedSecurity\=true. For example:
- Restart the Flow server.
You will also need sqljdbc_auth.dll in the Java library path used to run any jar utilities that needs to authenticate to this database, such as CleanupStalledJob-jar-with-dependencies.jar.