@solcani2, which version of KNIME AP are you using? Version 4.4 comes with the jTDS driver for sql server, and as you will see from a post I made on a related issue, I found the official Microsoft drivers were unreliable when it came to using Windows authentication whilst the jTDS driver just worked.