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 

 

 

5 REPLIES
Ten Stars

Re: SQL Input Connection Refused

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

Re: SQL Input Connection Refused

Of course see below

Ten Stars

Re: SQL Input Connection Refused

That all looks correct. You can connect to this server using other tools on the same box?
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 

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