No support for Windows Authentication Mode (SQL Server) in TOS?

One Star

No support for Windows Authentication Mode (SQL Server) in TOS?

I cannot connect to SQL Server unless I enable Mixed Mode (allow SQl server administration) security authentication.
Is windows authentication not supported in TOS for SQL server?
Maybe I am doing something wrong, but I see no options to specify windows authentication in Talend.
Additionaly, some DBAs do not allow SQL server authentication (for good reason), so hopefully someone can help with this.
dave
One Star

Re: No support for Windows Authentication Mode (SQL Server) in TOS?

Apparently, the secret is using sqljdbc_auth.dll, which is part of the newer Microsoft JDBC driver 3.0
The problem is that no posts on the forum have been successful at getting this to work.
Anybody out there successful with the new driver, and using Windows authentication?
Dave
Employee

Re: No support for Windows Authentication Mode (SQL Server) in TOS?

Hi David,
There are some posts on the forum which resolve this TOPIC.
http://www.talendforge.org/forum/viewtopic.php?id=2723
http://talendforge.org/forum/viewtopic.php?id=1031
Hope you'll have success to follow these steps and have the Windows Authentication working.
One Star

Re: No support for Windows Authentication Mode (SQL Server) in TOS?

Those are old posts you listed, and reference a no longer existent dll. The new dll is sqljdbc_auth.dll from Microsoft, and is contained in the MS newer jdbc driver, which has lots of features that support the newer versions of sql server, including 2008. I have placed that file in several folders, including the one referenced in the old posts that you listed. Does not work.
If you do a search for sqljdbc_auth in the Talend forum, you wil see that no one has got this to work with Talend. Very few DBAs allow sql server authentication - integrated securtity is what everybody uses.
If I cannot get this to work, I will be forced to use SSIS on this project.

Dave

Hi David,
There are some posts on the forum which resolve this TOPIC.
http://www.talendforge.org/forum/viewtopic.php?id=2723
http://talendforge.org/forum/viewtopic.php?id=1031
Hope you'll have success to follow these steps and have the Windows Authentication working.
Community Manager

Re: No support for Windows Authentication Mode (SQL Server) in TOS?

Hi David
Please report this issue to our bugtracker our developer will do a future investigation and fix it.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog