LoginTimedOutIssue_SqlServer_Connection_WindowsAuthenticationMode

[lvsiva]

Dear Team,

Am trying to connect SqlServer from Talend using Windows authentication mode,Getting Connection timed out error.

Some how I found an article which resolves this problem

**********

1.Download jtds-SQL server JDBC driver from https://sourceforge.net/projects/jtds/
Copy jtds-1.3.1.jar to ‘plugins’ of Talend folder
Based on your CPU architecture, copy ntlmauth.dll from x64/SSO OR x86/SSO OR IA64/SSO folder to <JDK_HOME>/bin folder
2.In SQL Server Network Configuration set all Protocols to Enabled.
Copy TCP dynamic ports value from TCP/IP protocols property from the end of the page.
3.In Talend Metadata > DB Connection, set the following properties.
DB Type = Microsoft SQL Server
DB Version = Open Source JTDS
Specify your Server name and Database
In additional parameters = integratedSecurity=true “most important”
In SQL Server Network Configuration set all Protocols to Enabled.
Use TCP dynamic ports from TCP/IP protocols property.

*****************

followed the steps, Even am unable to connect.

Guys can you please help me on this issue.

Thanks in Advance

[Anonymous]

Hello,

Could you please clarify in which Talend version/edition you are? What's SqlServer version are you trying to connect?

Best regards

Sabrina

[lvsiva]

Hi Sabrina,

Thanks for the reply.

SqlServerVersion: 2017

Talend: Openstudio 7.0.1

Thanks in Advance.

Regards,

Siva