LoginTimedOutIssue_SqlServer_Connection_WindowsAuthenticationMode

lvsiva — Fri, 26 Oct 2018 09:11:18 GMT

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

Re: LoginTimedOutIssue_SqlServer_Connection_WindowsAuthenticationMode

Anonymous — Tue, 13 Nov 2018 08:14:35 GMT

Hello,

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

Best regards

Sabrina

Re: LoginTimedOutIssue_SqlServer_Connection_WindowsAuthenticationMode

lvsiva — Thu, 15 Nov 2018 15:09:10 GMT

Hi Sabrina,

Thanks for the reply.

SqlServerVersion: 2017

Talend: Openstudio 7.0.1

Thanks in Advance.

Regards,

Siva

topic Re: LoginTimedOutIssue_SqlServer_Connection_WindowsAuthenticationMode in Talend Studio

LoginTimedOutIssue_SqlServer_Connection_WindowsAuthenticationMode

Re: LoginTimedOutIssue_SqlServer_Connection_WindowsAuthenticationMode

Re: LoginTimedOutIssue_SqlServer_Connection_WindowsAuthenticationMode