I'd like to install TAC with MS SQL Server as it's database.
Is it possible to use Windows Authentication?
Yes it is possible if you are using the ntlmauth dll. You will give the service account starting the TAC the access to the database. Then you put the dll and jtds jar into the TAC Tomcat folder. You may need to put the dll in the windows and Java JDK/JRE bin folders. In TAC for the JDBC URL, specify the right url without username/password.
I found this short video helpful when trying to read tables from an MS SQL Server -
I can now read from our server without using a SQL login. It uses my Windows login instead.
(Obviously, this only helps Windows users, not the growing number of Linux users.)
One more way to achieve would be using the OLEDB approach .
Detailed explanation here - http://bekwam.blogspot.com/2014/05/talend-to-ms-sql-with-windows.html