topic Re: Connection failure: SQLException: Login Timed Out in Talend Studio

Connection failure: SQLException: Login Timed Out

Anonymous — Sat, 16 Nov 2024 07:07:15 GMT

Hi, I am trying to connect to a SQL Server through Talend and this error shows up:

I have access to the database to another server but on this other server, Talend won't let me connect with the database.

Any ideas of what is wrong?

Java version is: "1.8.0_172"
Java(TM) SE Runtime Environment (build 1.8.0_172-b11)
Java HotSpot(TM) 64-Bit Server VM (build 25.172-b11, mixed mode)

Thank you.

Re: Connection failure: SQLException: Login Timed Out

vapukov — Wed, 05 Dec 2018 21:50:07 GMT

simplest check - connect from same machine(server) to target SQL server with used in talend name, instance name, port and check

timeout in most of the cases (99,99%) - or wrong information (non standard port, dns error for server name etc) or network firewall rules

Re: Connection failure: SQLException: Login Timed Out

Anonymous — Thu, 06 Dec 2018 12:30:49 GMT

Hi, thank you for your answer. But I'm sure I wrote the right instance name, password and database. I have Talend in another server and when I try to connect to the database I want it works just fine, but when I do it for Talend that is in another server, the login timed out shows up. I don't think it makes any sense?

Re: Connection failure: SQLException: Login Timed Out

vapukov — Thu, 06 Dec 2018 20:16:40 GMT

@kayeann wrote:

Hi, thank you for your answer. But I'm sure I wrote the right instance name, password and database. I have Talend in another server and when I try to connect to the database I want it works just fine, but when I do it for Talend that is in another server, the login timed out shows up. I don't think it makes any sense?

this is why I wrote - you need to check connection from current server with classic sql tools - studio or command line clien