Connection failure: SQLException: Login Timed Out

Five Stars

Connection failure: SQLException: Login Timed Out

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

 

 

image.png

 

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.

Thirteen Stars

Re: Connection failure: SQLException: Login Timed Out

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

-----------
Five Stars

Re: Connection failure: SQLException: Login Timed Out

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? 

Highlighted
Thirteen Stars

Re: Connection failure: SQLException: Login Timed Out


@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

-----------

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.