SQL Input Connection Refused

Highlighted
Five Stars

SQL Input Connection Refused

Hi ,

Trying to connect to MSSQLServer and getting  a connection refused message which I cant figure out why. Connection works in other products. TCPIP is enabled, using correct port 1433, Using a SQL Login, details have been inputted correctly... not sure what else it can be?

 

Error 

 

 

Highlighted
Ten Stars

Re: SQL Input Connection Refused

Can you show a screenshot of your connection settings?
Highlighted
Five Stars

Re: SQL Input Connection Refused

Of course see below

Highlighted
Ten Stars

Re: SQL Input Connection Refused

That all looks correct. You can connect to this server using other tools on the same box?
Highlighted
Five Stars

Re: SQL Input Connection Refused

Yes. Its actually just a local SQL on my laptop at the moment but can connect through SSIS using the same credentials with no issue. Just not trough Talend 

Highlighted
Ten Stars

Re: SQL Input Connection Refused

https://stackoverflow.com/questions/18841744/jdbc-connection-failed-error-tcp-ip-connection-to-host-...

 

Suggestions include verifying the database configuration allows for tcpip connections, verifying the port number, and making sure a local firewall isn't preventing the connection

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog