topic Re: connection to MS SQL SERVER not work in Talend Studio

connection to MS SQL SERVER not work

Anonymous — Sat, 16 Nov 2024 14:10:45 GMT

hello Everybody,
I use new version of talend (TOS 3.0.0). I would like to use the components about MS SQL SERVER database.
So when i create db connection, that not work. Error message : "Connection failure. You must change the Database Settings.
Network error IOException: Connection refused: connect"
Please what i do??
thanks

Re: connection to MS SQL SERVER not work

Anonymous — Thu, 30 Oct 2008 00:12:09 GMT

Hi,
MSSQL needs to be configure to accept remote connection and also the firewall needs to allow traffic.
have a look at this page:
http://jtds.sourceforge.net/faq.html#connectionRefused
this is the website for the project that develops MSSQL java driver.

Nicolas

Re: connection to MS SQL SERVER not work

Anonymous — Thu, 30 Oct 2008 10:04:01 GMT

hello,
That work with MS SQL SERVER but i use MS SQL SERVER EXPRESS Edition and that not work.
can you help me please??

Re: connection to MS SQL SERVER not work

Anonymous — Thu, 30 Oct 2008 10:10:01 GMT

Hello,
MS SQL EXPRESS has named instances
So you have to fill Additional Parameters field
Try using:
Additional Parameters: instance=SQLEXPRESS

José

Re: connection to MS SQL SERVER not work

Anonymous — Thu, 30 Oct 2008 10:25:05 GMT

Hi,
I do it but that not work. the erro is "Unable to get information from SQL Server: S-XXXXXXXXXXX"
this is the string of connection :

 jdbc:jtds:sqlserver://S-XXXXXXXXXXX:1433/Base_FR;instance=SQLEXPRESS

generated by talend
Thank

Re: connection to MS SQL SERVER not work

Anonymous — Thu, 30 Oct 2008 11:02:51 GMT

rgent,
have you tried this:
http://jtds.sourceforge.net/faq.html#instanceGetInfo

Re: connection to MS SQL SERVER not work

_AnonymousUser — Tue, 30 Dec 2008 15:42:13 GMT

In Sql Server Express 2008 try to : start - programs - microsoft sql server 2008 - configuaration tools - sql server configuration monitor - find the node ''protocols for..." and enable tcp-ip.

Re: connection to MS SQL SERVER not work

_AnonymousUser — Tue, 30 Dec 2008 15:43:45 GMT

Important: stop/start the service to keep updates.

Re: connection to MS SQL SERVER not work

_AnonymousUser — Thu, 26 Mar 2009 15:27:52 GMT

I have the same problem, with the same error Connection failure. You must change the Database Settings.
Unable to get information from SQL Server: SERVERNAME
I enable TCP/IP for MS SQL SERVER but not resolve.
Via ODBC , i connected DB. But i have an unsopported future.

Re: connection to MS SQL SERVER not work

_AnonymousUser — Wed, 30 Nov 2011 04:28:51 GMT

I left the schema field empty and added instance=<instanceName> in Additional Parameters.
The String of Connection should look like
jdbc:jtds:sqlserver://<server>:<port>/<database>;instance=<instanceName>
Hope it helps

Re: connection to MS SQL SERVER not work

Anonymous — Wed, 26 Mar 2014 09:58:12 GMT

In Sql Server Express 2008 try to : start - programs - microsoft sql server 2008 - configuaration tools - sql server configuration monitor - find the node ''protocols for..." and enable tcp-ip.

This is a right way i have enabled tcp-ip and then successfully connect with talend.
Thanks