connection to MS SQL SERVER not work

One Star

connection to MS SQL SERVER not work

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

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
One Star

Re: connection to MS SQL SERVER not work

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

Re: connection to MS SQL SERVER not work

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

José
One Star

Re: connection to MS SQL SERVER not work

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

One Star

Re: connection to MS SQL SERVER not work

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.
One Star

Re: connection to MS SQL SERVER not work

Important: stop/start the service to keep updates.
One Star

Re: connection to MS SQL SERVER not work

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.
One Star

Re: connection to MS SQL SERVER not work

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

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