Four Stars

TAC with MS SQL Server using Windows Authentication

I'd like to install TAC with MS SQL Server as it's database.

 

Is it possible to use Windows Authentication?

  • Talend Administration Center
2 REPLIES
Employee

Re: TAC with MS SQL Server using 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.

One Star

Re: TAC with MS SQL Server using Windows Authentication

I found this short video helpful when trying to read tables from an MS SQL Server -

https://www.youtube.com/watch?v=pXFazmPcqX8

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.)

Jon