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
4 REPLIES
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