topic TAC with MS SQL Server using Windows Authentication in Installing and Upgrading

TAC with MS SQL Server using Windows Authentication

Anonymous — Sat, 16 Nov 2024 09:30:39 GMT

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

Is it possible to use Windows Authentication?

Re: TAC with MS SQL Server using Windows Authentication

Anonymous — Tue, 18 Jul 2017 17:06:17 GMT

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.

Re: TAC with MS SQL Server using Windows Authentication

JonLester — Fri, 21 Jul 2017 12:40:43 GMT

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

Re: TAC with MS SQL Server using Windows Authentication

iamabhishek — Thu, 31 May 2018 15:57:52 GMT

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