Hi,
KNIME connects to databases via jdbc. By using the jdbc driver provided by Microsoft you should be able to conect to your database via windows authentication.
To establish the connection you have to register the MS jdbc driver in KNIME as described in the first section of the database documentation. You then also need to make sure that the jdbc driver finds the sqljdbc_auth.dll. To do so, you have to edit the knime.ini file which is located in the root directory of your KNIME installation. Open the knime.ini file in a text editor and add the VM argument -Djava.library.path=<path to dll> with the path to the dll and restart KNIME.
In KNIME you can use the Database Connector node to establish a connection to any jdbc compliant db. Open the dialog of the node and select the microsoft jdbc driver from the database driver list. Enter the jdbc connection string to your database in the database url field including the integratedSecurity=true option e.g.
jdbc:sqlserver{HOST};Database={DB_NAME};integratedSecurity=true
Bye,
Tobias