topic Re: SQL Input Connection Refused in Talend Studio

SQL Input Connection Refused

Anonymous — Fri, 23 Jun 2017 15:47:18 GMT

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

Re: SQL Input Connection Refused

cterenzi — Fri, 23 Jun 2017 16:13:52 GMT

Can you show a screenshot of your connection settings?

Re: SQL Input Connection Refused

Anonymous — Fri, 23 Jun 2017 16:21:01 GMT

Of course see below

Connection.PNG

Re: SQL Input Connection Refused

cterenzi — Fri, 23 Jun 2017 16:52:05 GMT

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

Re: SQL Input Connection Refused

Anonymous — Fri, 23 Jun 2017 16:59:23 GMT

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

Re: SQL Input Connection Refused

cterenzi — Sat, 24 Jun 2017 04:17:18 GMT

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

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