Problem Description

The old SQL JDBC drivers were not supporting windows based authentication. In order to use AD windows authentication in Infoworks SQL source, we were using JTDS driver. But now the latest Microsoft SQL JDBC driver supports Windows AD-based authentication.


Please follow the below steps to configure a SQL server source with Windows AD based authentication,

  1. Login to the edge node
  2. cd $IW_HOME/bin ; source

  3. Download latest mssql driver from below link & put it under $IW_HOME/lib/shared/ and move the older sqljdbc41.jar to a temporary location                                                                                  

  4. Set the Connection string format similar to below in the SQL server source configuration setup      

Applicable IWX versions

Datafoundry 2.9.x, 3.x