Are you trying to add a connection in Talend to Microsoft SQL Server and receiving the “Impossible to Initialize the Connection” error?
In certain versions of Talend Open Studio for Data Integration, there are issues related to Microsoft SQL Server SSO. Single Sign On (or Windows authentication) does not seem to properly work in Talend Open Studio until version 5.2.1.
In previous versions, you would have to substitute the desired pass through authentication with SQL Server authentication. Beginning in Talend Open Studio 5.2.1 it appears to finally be corrected.
If you haven’t updated yet and desire to use SQL Server connections in Talend, then now is the best time ever!
For those awaiting release level 5.2 of Talend Open Studio for Data Integration, there is now a milestone release available from Talend’s website. For those awaiting a fix for the problems with connecting to SQL Server 2008 R2 using Windows Authentication, sorry to say but the problem is not corrected.
A solution remains to simple use SQL Server authentication, and that works, but this seems specifically to be a bug in the adding the connection and retrieving schema only. If you create the connection and it errors and then manually define a schema for a table stored on your SQL Server 2008 R2 database, it will actually query the data successfully. This means that they have attempted to make Windows Authentication work, but are not fixing certain bugs associated with it.
Although using SQL Server authentication is a valid work around, it is not an acceptable method to rely on long term. Hopefully Talend still chooses to address this.
When this error is encountered, it is because a process is seeking to use your windows credentials to connect to a Microsoft SQL Server. When a Java application using jDTS attempts a Single Signon to MS SQL Serve, a library is needed on the machine. This is the ntlmauth.dll library which is often missing when you move your code from development to production.
This file must exist in the system’s path. When on a Windows system, a good place to put it is in the Windows\System32 folder.
The library is available for download from the jDTS project at the following address: jDTS Project – Downloads
There is a bug in Talend Open Studio for Data Integration version 5.0.2 when trying to connect to SQL Server without passing a user name and password. Java requires libraries for single signon for this to occur, specifically the ntlmauth.dll file for the system. However, in Talend Open Studio 5.0.2, having this file does not allow single sign on to Microsoft SQL Server. This is confirmed on Microsoft SQL Server 2008 R2 64-bit.
When attempting to connect without supplying a username and password, the following error is received:
This issue is fixed in production release 5.1.1 of Talend Open Studio. A workaround in version 5.0.2 is not available at this time.
There is a bug in Talend Open Studio for Data Integration version 5.1.1 when adding a database connection. It has to do with the jdts component used for Microsoft SQL Server connections. When adding a new connection you may get one of the following errors:
The above error usually appears the first time you hit the button to “Check” the connection. The second and subsequent attempts will produce a different error message as follows:
This is a bug in Talend Open Studio for Data Integration that has a fix already implemented in the future 5.1.2 version.